* Confirm that “SQL Server Management Studio Express” is installed on the same machine that will host the database. * Log into “SQL Server Management Studio Express” with SQL … GEOTAB: Backing up a SQL Database Feb 24, 2008 1 | Page www.geotab.com l email: geosupport@geotab.com l Main Toll-free +1 (877) 436-8221 l Backing-up an SQL database:* Find the machine that hosts the database.* Confirm that “SQL Server Management Studio Express” is installed on the same machine that hosts the database.* Log into “SQL Server …
GEOTAB: Backing up a SQL Database Feb 24, 2008 4 | Page www.geotab.com l email: geosupport@geotab.com l Main Toll-free +1 (877) 436-8221 l * Take note of the path to the folder in which the backup file will be saved (C:\Program Files\Microsoft SQL Server\MSSQL\OLAP\Data\MSSQL.1\MSSQL\Backup), and in the “File name” field, enter the name that you want to give to the backup file: * In the top left corner of the “Back UpDatabase” window, click on “Options”. This will display the following window. Check the “Verify backup when finished” box: * In the bottom right corner of the same window, click “OK”. Management Studio will now begin backing up your database. * Once the backup is completed successfully, the following message will be displayed Restoring an SQL database: * Find the machine that will host the database. * Confirm that “SQL Server Management Studio Express” is installed on the same machine that will host the database. * Log into “SQL Server Management Studio Express” with SQL authentication or Windows authentication:
Download Backing-up an SQL database Backup Restore SQL Database.
0 comments:
Post a Comment