SQL Server Backup problem 1

[MMund]

I am a newbie to this part of SQL Server, and am attempting to do a backup, and get this error:

Backup failed. Set property devices to accomplish this action.

This worked yesterday, but not now, and I'm not doing anything differently. Ideas?

 

[SQLBill]

Don't know. First thing that would help us is to know what version of SQL Server you are using and how you are trying to do the backup.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[MMund]

Version is 2005, we are going though the Management Studio, right-clicking on the database we want to back up, and then going through Tasks>Backup.

 

[juliane26]

Which backup device do you select?

Select disc (and not tape) then select 'add' and enter a path and filename(like dbname.BAK) for your backup.

Juliane

 

[SQLBill]

I prefer to use TSQL commands instead of the GUI.

BACKUP DATABASE mydb
TO DISK = 'c:\backups\mydb.bak'

You can make the path be wherever you need the file to go.

Refer to the Books OnLine that come with SQL Server.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875