Backup Database

[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

[bharadwaj]

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

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

[japuentem]

try this
BACKUP DATABASE abc
TO DISK='C:\backup s\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