The path may be different on your computer: USE įROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\SQLTestDB.bak' WITH FILE = 1, NOUNLOAD, STATS = 5 Select OK to restore the backup of your database.Īlternatively, you can run the following Transact-SQL script to restore your database. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |