Embedded Files
Restore
Restore
ALTER DATABASE YourDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE
In SSMS...
Right click your database
Tasks - Restore
Review General and Options pages
Restore from multiple file backup
Restore from multiple file backup
RESTORE DATABASE myDatabase
FROM DISK=N'G:\SQL Backups\myDatabase\myDatabase_Full_1.bak',
DISK=N'H:\SQL Backups\myDatabase\myDatabase_Full_2.bak',
DISK=N'I:\SQL Backups\myDatabase\myDatabase_Full_3.bak',
DISK=N'J:\SQL Backups\myDatabase\myDatabase_Full_4.bak'
WITH NORECOVERY;
RESTORE DATABASE myDatabase
WITH RECOVERY;
Restore AdventureWorks
Restore AdventureWorks
Assumes the AdventureWorks backup has been transferred to the backup location on your server.
SQL2012 - Restore AdventureWorks to empty instance...
SQL2012 - Restore AdventureWorks to empty instance...
Check Files and Options are correct before pressing OK (but defaults should be fine)
Defaults should be fine
Defaults should be fine
Bibliography
Bibliography
https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configurehttps://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks2008r2https://www.sqlservercentral.com/articles/sql-server-sample-databaseshttps://www.sqlskills.com/sql-server-resources/sql-server-demos/https://www.brentozar.com/archive/2014/01/improving-the-performance-of-backups/
Restore Scripthttps://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/https://www.mssqltips.com/sqlservertip/1243/auto-generate-sql-server-database-restore-scripts/
SQL2008https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms186858(v=sql.105)
Restore Scripthttps://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/https://www.mssqltips.com/sqlservertip/1243/auto-generate-sql-server-database-restore-scripts/
SQL2008https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms186858(v=sql.105)
Page updated
Google Sites
Report abuse