March 9, 2009 at 9:28 am
as a follow up to the post that I just submitted,
I should point out that the device name confusingly has the same name as the database name itself so the command
BACKUP DATABASE sample_db TO sample_db WITH DIFFERENTIAL
go
means backup the database sample_db to the device sample_db as listed in sp_helpdevice.
sp_helpdevice
DEVICE_NAMEPHYSICAL_NAME
sample_dbs:\backups\sample_db.dat
sample_dbLogs:\backups\sample_dbLog.dat
March 9, 2009 at 9:37 am
bill (3/9/2009)STEP 2 (Conditional on STEP 1 being successful): BACKUP LOG sample_db TO sample_DbLog WITH INIT
As soon as you issue the above command, you can no longer restore to a point in time prior to that backup since you have initialized the backup device. You would need a copy of the backup device - or be able to insure a valid copy with all transaction log backups has been copied to tape before initializing the device.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply