Wednesday, August 17, 2016

multiple database backup simultaniously using sql script

Now Its easy to take the multiple database backup  simultaniously using below script. Below script  is only for sql server



USE MASTER
GO

BACKUP DATABASE [PraveenDB]
TO DISK = 'D:\05312011\PraveenDB.bak'
GO

BACKUP DATABASE [TestDB]
TO DISK = 'D:\05312011\TestDB.bak'
GO

BACKUP DATABASE [Lookups]
TO DISK = 'D:\05312011\Lookups.bak'
GO

BACKUP DATABASE [StudentDB]
TO DISK = 'D:\05312011\StudentDB.bak'
GO

BACKUP DATABASE [ResultDB]
TO DISK = 'D:\05312011\ResultDB.bak'
GO