And if you want to test recovery, you can restore the .bak to a different (new) database without overwriting the current database.
From: [email protected] [mailto:[email protected]] Sent: Tuesday, September 29, 2009 8:29 AM To: NT System Admin Issues Subject: Re: Am I backing up SQL correctly? Yes. Sent from my Verizon Wireless BlackBerry _____ From: "James Kerr" Date: Tue, 29 Sep 2009 11:09:04 -0400 To: NT System Admin Issues<[email protected]> Subject: Am I backing up SQL correctly? I have an MS SQL 2003 database that I backup by having it run its own backup of the databases and it creates .bak files. Then later on in the evening I have BE backup those .bak files to tape. These .bak files should allow me to restore a database right? James ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
