Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mr_dayal
Starting Member
37 Posts |
 Posted - 2008-07-18 : 08:36:33
|
| I am using local database xyz.mdf located in c:\inetpub\wwwroot\test\app_data for a web site.Now i want to backup the databse from sql commandUSE master BACKUP DATABASE [xyz.mdf] TO DISK =something.datBut It is not working"Could not locate entry in sysdatabases for database 'Jhar_sd_data.mdf'. No entry found with that name. Make sure that the name is entered correctly. BACKUP DATABASE is terminating abnormally. Changed database context to 'master'."What Could be the problem?Thanks in Advance.Mr Dayal |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-18 : 09:02:24
|
| you don't do like that. BAckup database <yourdbname> to disk = pathCheck books online which comes with SQL server. |
 |
|
|
|
|
|
sql command to backup databse of sqlserver 2005 ex