i am working with internal sql server 2008 with VS-2010
Now, I want to add new functionaliti in my website for taking whole backup of database
I tried following query for backup:
BACKUP DATABASE DB1 TO DISK = N'D:\\DB1.bak' WITH NOFORMAT, NOINIT, NAME = N'DB1-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
But Following Error is Generated At the time of Execution:
Database 'DB1' does not exist. Make sure that the name is entered correctly.
BACKUP DATABASE is terminating abnormally.
So, Any one help me in this problem
View Complete Post