Viewing 6 posts - 16 through 21 (of 21 total)
Hi Josh,
If you just increased the database file size on the source end then it should be propogated automatically to the destination end of log shipping and there is no...
January 4, 2012 at 9:08 am
if you want selective table data only then my way will not work since log backup has a record of all changes made to all the database object and not...
January 3, 2012 at 2:09 pm
If you still have
1. full backup of xyz database with which you created\restored xyz_qa on DEF instance and
2. Transaction Log backups of xyz database after that full backup...
January 3, 2012 at 2:05 pm
Seems you misunderstood, if the recovery model of the database is full then the log will not be cleared unless the log backup or the full database backup is performed
January 3, 2012 at 1:49 pm
one way to do it is to setup trace to run and capture the events you want and it can be filtered based on the users, databases etc.
If you use...
January 3, 2012 at 11:39 am
if the database is not too big, I will recommend going for nightly full backup with hourly or 2 hourly log backup to clear the logs. If the database...
January 3, 2012 at 11:34 am
Viewing 6 posts - 16 through 21 (of 21 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy