I did a upgrade to 2.0 from 1.3 one hour ago and when I want to backup my database I get this error:
Can not open backup device c:\documents and settings\owner\my documents\aaa.bck'. operating system error 5 (access is denied). Backup Database is terminating abnormaly
HELP
version 2.0.0105
Can you change the path to where the backup is happening? For example, C:\aaa.bck Sounds like either A, you don't have permissions to the folder that you are trying to write to, or B, the folder you are trying to write to does not exist. Mike
Also the folder has to be a SHARED folder.
Mike G wrote:
not the file..the folder. Try backup to the SHARED folder of your computer. That's what worked for us.
iraj wrote:
Ok I was able to back it up to this location, and I dont know why I just cant backit up lets say on my desktop like I use to with 1.3 version, but here is the location I was able to back it up C:\Program files\microsoft sql server\mssql.1\mssql\backup do I have to alway save it there, or is it a way just to backit up on the desktop or somewhere else thanks in advance
"iraj" wrote:
I just tried backing up my 1.3 system after going to SQL Server 2005 Express. I used same command files as before with MSDE. All worked without a problem. Here are the command file contents:
BACKUP_POSdb.bat @echo off dir "c:\Program Files\Microsoft SQL Server\MSSQL\Data\saec*" del d:\transfer\saec\saec.bak osql -E -i "D:\Transfer\\saec\backup_POSdb.sql" pause exit
BACKUP_POSdb.sql backup database saec to disk = 'd:\transfer\saec\saec.bak' with format,stats go
Hope that helps.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required