![]() Select OK to close the Select backup devices dialog box. Select Device:, and then select the ellipses (.) to locate your backup file. Right-click the Databases node in Object Explorer and select Restore Database. To restore your database, follow these steps: To take a backup of your database, follow these steps: Refresh the Databases node in Object Explorer to see your new database. INSERT INTO SQLTest (ID, c1) VALUES (5, 'test5') ![]() INSERT INTO SQLTest (ID, c1) VALUES (4, 'test4') INSERT INTO SQLTest (ID, c1) VALUES (3, 'test3') INSERT INTO SQLTest (ID, c1) VALUES (2, 'test2') ![]() INSERT INTO SQLTest (ID, c1) VALUES (1, 'test1') Run the following Transact-SQL (T-SQL) code to create your test database. Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance. In this quickstart, you create a new database, take a full backup of it, and then restore it.įor a more detailed how-to, see Create a full database backup and Restore a backup using SSMS. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |