Tuesday, August 19, 2014

How to take SQL database back via SQL Script

BACKUP DATABASE [MyDatabaseName]
TO DISK = N'C:\MyDatabaseName.bak'
GO
BACKUP LOG [MyDatabaseName]
TO DISK = N'C:\MyDatabaseName.bak'
GO