Feb 22, 2008 #1 MMund Programmer Oct 9, 2007 57 0 0 CA 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?
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?
Feb 22, 2008 1 #2 SQLBill MIS May 29, 2001 7,777 0 0 US 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 Upvote 0 Downvote
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
Feb 25, 2008 Thread starter #3 MMund Programmer Oct 9, 2007 57 0 0 CA 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. Upvote 0 Downvote
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.
Feb 26, 2008 #4 juliane26 Technical User Mar 10, 2004 207 0 0 GB 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 Upvote 0 Downvote
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
Feb 26, 2008 #5 SQLBill MIS May 29, 2001 7,777 0 0 US I prefer to use TSQL commands instead of the GUI. Code: 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 Upvote 0 Downvote
I prefer to use TSQL commands instead of the GUI. Code: 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