-
Backup Database
i am trying to backup a database but couldn't find any solution to it the last tecnique i used was that i made a procedure in which i write
BACKUP DATABASE database name
TO DISK ='E:/database.bak'
But i got the following Exception/Error
"Could not locate entry in sysdatabases for database 'DB_1'. No entry found with that name. Make sure that the name is entered correctly.
BACKUP DATABASE is terminating abnormally." :mad:
-
Sounds db name is not correct.
-
Syntax Error
It seems you have 2 syntax errors:
- If your database has spaces in the name try using [Database Name].
- You're using a slash instead of a backslash in the file path.
If your backup is not too complex you could try this tool SQL Backup and FTP