Viewing 3 posts - 1 through 4 (of 4 total)
It will make things easier for the transaction log backups for each database to be in its own backup device.
You can still restore items from the mixed backup device, just...
Peter Yeoh
Developer
Red Gate Software
February 11, 2007 at 7:17 pm
A transaction log backup does not cause the database transaction logs to be 'cleared'. In the above scenario, a transaction log backup performed after the full backup will still contain transactions...
Peter Yeoh
Developer
Red Gate Software
January 22, 2007 at 11:05 pm
SQL Server has 3 recovery models - simple, bulk-logged and full. Depending on your data recovery needs, you need to choose the recovery model that is most suitable for you. ...
Peter Yeoh
Developer
Red Gate Software
January 22, 2007 at 10:41 pm
Viewing 3 posts - 1 through 4 (of 4 total)