Sunday, March 11, 2012

Backup Database

I want to backup a database with the SQL Query Analizer with the following instruction:

BACKUP DATABASE my_database
TO DISK 'C:\backups\my_database.bak'
WITH FORMAT
GO

and send me this error

Cannot open backup device 'C:\backups\my_database.bak'. Operating system error 3 (error not found)

BACKUP DATABASE is terminating abnormally

Please help me

Regardstry this
BACKUP DATABASE abc
TO DISK='C:\backups\abc.bak'
WITH FORMAT
GO

Quote:

Originally Posted by japuentem

I want to backup a database with the SQL Query Analizer with the following instruction:

BACKUP DATABASE my_database
TO DISK 'C:\backups\my_database.bak'
WITH FORMAT
GO

and send me this error

Cannot open backup device 'C:\backups\my_database.bak'. Operating system error 3 (error not found)

BACKUP DATABASE is terminating abnormally

Please help me

Regards

|||

Quote:

Originally Posted by bharadwaj

try this
BACKUP DATABASE abc
TO DISK='C:\backups\abc.bak'
WITH FORMAT
GO


I think the problem is because the database is not in the local server, i have the database in a remote server

No comments:

Post a Comment