thank you.
Use Backup in SQL Server 2008
I want to know how to use backup in SQL Server 2008.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pradip PandeyPosted Aug 15, 2012, 3:02 AM
Create a folder called < BackupDt150812> in your c: drive.
In SQL Query Analyzer, write the syntax
BACKUP DATABASE [test] TO DISK = N'C:\BackupDt150812\test.bak' WITH NOFORMAT, NOINIT, NAME = N'test-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO