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