Post reply

How to associate a database with a backup device

  • February 3, 2009 at 2:18 pm

    #206271

    I have a SQL 2005 server running several database. I need to know if there is a method using a stored procedure to associate each database with a backup device.

  • February 3, 2009 at 3:09 pm

    #937601

    No. A logical backup device isn't explicitly associated with a database. The only way to imply an association is by naming and by using the device in backup statements.

    Greg

  • February 3, 2009 at 3:18 pm

    #937607

    So can you set a default backup device for the server?

  • February 3, 2009 at 4:01 pm

    #937630

    Backup devices are obsolete features left over from earlier versions of SQL Server.

    Just backup to individual backup files with a time stamped name.

    Example:

    MyDBName_db_20091231_135344.bak

    This is how a database maintenance plan handles it.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply