Post reply

backup of Database/tables

  • May 16, 2006 at 10:05 am

    #114651

    Using a Veritas backup sql agent - can you restore one sql 2000 table? 

  • May 16, 2006 at 10:32 am

    #638210

    No. You have to restore the whole database. You can restore the database to another instance or as another name and then import the table into the original database.

    -SQLBill

  • May 16, 2006 at 11:07 am

    #638229

    Thank you!

  • May 17, 2006 at 8:17 am

    #638423

    One thing to keep in mind...  test your recovery plan!  In my experience, agent-mediated SQL Server to tape backups are prone to failure.  Even apparently successful backups will fail to restore.  We completely eliminated them and switched to disk based and then backed up the disk files to tape -- no problems since then...

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

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