Backup Database problems Help

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.