| Description: |
How to backup and restore databases?
Resolution:
To back up a database:
- On the SQL server, launch SQL Server Management Studio and connect to the correct SQL database engine.
- Expand the Database folder.
- Right click on your database and choose Tasks > Backup.
- Under Destination, confirm that the path to your backup folder is correct.
• If you need to change the path, click Remove, then click Add.
- Use the ellipses to navigate to a specific folder.
• Note only a folder only on a local drive is available, not a mapped drive. Move the backup file later as needed.
- Give the backup file a unique filename with the extension of .BAK.
• It is a good practice to include the database name and a date tag within the filename, for easy identification.
- Click OK, OK, and OK to begin the backup.
To restore a database that does not already exist: (from a backup of another database)
- On the SQL server, launch SQL Server Management Studio and connect to the correct SQL database engine.
- Right click on the Database group and click Restore Database.
- On the General page, under Source, choose Device.
- Use the ellipses to navigate to the folder where the backup resides.
- Select Add, highlight the BAK file, and click OK, OK.
- Under Destination, the name that appears will be the name of the database from which the backup was taken.
• Change this to specify the name for the restored database.
- Hit TAB. Do not hit OK yet.
- In the left panel, select Files.
- In the grid at the right, notice the path in the column called Restore As.
• If this location is not correct, click the box Relocate All Files to Folder, and specify the folder locations for the data file and the log file.
• The data file (.mdf) and log file (.ldf) may be on the same or different physical drives.
- Click OK to begin the restore.
To restore a database that already exists: (to OVERWRITE it)
- On the SQL server, launch SQL Server Management Studio and connect to the correct SQL database engine.
- Right click on the database name and click Tasks > Restore > Database.
- On the General page, the database name will appear as both the Source and the Destination.
- Check the date of the backup to make sure this is correct.
- If the Source is not correct, select Device, use the ellipses to navigate to the correct backup file, and click OK one time only.
- In the left panel, select Files.
- In the grid at the right, notice the column called Restore As. Verify that the folder locations are correct.
- In the left panel, select Options.
- Select Overwrite the Existing Database (WITH REPLACE).
- Click OK to begin the restore.
To verify the Weblink Configuration for a restored database:
- On the Web\Application Server, launch Weblink.
- Enter the Weblink password.
- Select the record for the database.
- If you are setting up a new database, select New > Copy Current and specify the new database name.
- Verify the information on this page.
- Click Test > Database Connection to confirm that the specifications are correct.
- Save the changes.
|