Guest User

Untitled

a guest
Dec 17th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. BACKUP DATABASE [itdba] TO DISK = N'D:multipleDatabaseBackup.bak' WITH NOFORMAT, NOINIT,NAME = N'itdba_backup'
  2. GO
  3. BACKUP DATABASE [itdbatest] TO DISK = N'D:multipleDatabaseBackup.bak' WITH NOFORMAT, NOINIT, NAME = N'itdbatest_backup'
  4. GO
  5. BACKUP DATABASE [itdbatest2] TO DISK = N'D:multipleDatabaseBackup.bak' WITH NOFORMAT, NOINIT, NAME = N'itdbatest2_backup'
  6. GO
  7.  
  8. RESTORE HEADERONLY FROM DISK = N'D:multipleDatabaseBackup.bak'
  9.  
  10. RESTORE DATABASE itdbatest FROM DISK = N'C:Program FilesMicrosoft SQL ServerMSSQL14.SQL2017MSSQLBackupmultipleDatabaseBackup.bak'
  11. WITH REPLACE, FILE = 2,
  12. MOVE 'ITDBATest' TO 'C:Program FilesMicrosoft SQL ServerMSSQL14.SQL2017MSSQLDATAITDBATest.mdf',
  13. MOVE 'ITDBATest_log' TO 'C:Program FilesMicrosoft SQL ServerMSSQL14.SQL2017MSSQLDATAITDBATest_log.ldf'
  14. GO
Add Comment
Please, Sign In to add comment