Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BACKUP DATABASE [itdba] TO DISK = N'D:multipleDatabaseBackup.bak' WITH NOFORMAT, NOINIT,NAME = N'itdba_backup'
- GO
- BACKUP DATABASE [itdbatest] TO DISK = N'D:multipleDatabaseBackup.bak' WITH NOFORMAT, NOINIT, NAME = N'itdbatest_backup'
- GO
- BACKUP DATABASE [itdbatest2] TO DISK = N'D:multipleDatabaseBackup.bak' WITH NOFORMAT, NOINIT, NAME = N'itdbatest2_backup'
- GO
- RESTORE HEADERONLY FROM DISK = N'D:multipleDatabaseBackup.bak'
- RESTORE DATABASE itdbatest FROM DISK = N'C:Program FilesMicrosoft SQL ServerMSSQL14.SQL2017MSSQLBackupmultipleDatabaseBackup.bak'
- WITH REPLACE, FILE = 2,
- MOVE 'ITDBATest' TO 'C:Program FilesMicrosoft SQL ServerMSSQL14.SQL2017MSSQLDATAITDBATest.mdf',
- MOVE 'ITDBATest_log' TO 'C:Program FilesMicrosoft SQL ServerMSSQL14.SQL2017MSSQLDATAITDBATest_log.ldf'
- GO
Add Comment
Please, Sign In to add comment