Viewing 13 posts - 1 through 13 (of 13 total)
@SSCommitted
That was it. Thank You!
August 19, 2011 at 3:54 pm
Thank you for all your help! In case anyone else wanted to know it's slightly different:
exec sp_change_log_shipping_secondary_primary
@primary_server = 'LAP8EA01',
@primary_database = 'MainDb',
@file_retention_period = '8640'
August 16, 2011 at 11:03 am
and for the secondary server I would do this?
exec sp_change_log_shipping_secondary_primary @database = 'MainDb',
@ file_retention_period = '8640'
August 16, 2011 at 10:36 am
Yeah, that would have saved some time, so sorry, I thought mentioned it. Here is the mirror/primary output. Is it safe to just manually update the backup_retention_period field?...
August 16, 2011 at 9:39 am
yes, database mirroring. Sorry, I thought I specified my setup. I knew that mirrored db's don't perform log shipping, but I didn't realize that they DO delete logs......
August 15, 2011 at 5:59 pm
Ahh, sorry guys, it was the mirror deleting the logs too soon. The principle was saying deleting old logs, but the mirror says deleting old logs and gives the...
August 15, 2011 at 4:46 pm
Here is the information requested. However, note the secondary database retention time wasn't increased because I haven't set that yet, this shouldn't affect the first location retention period tho right?...
August 15, 2011 at 9:13 am
Yeah, my first post shows the field... is there another place somewhere? Also, I did use the wizard to set this. Should it be ok to just change this value...
August 12, 2011 at 11:42 am
The server times are the same. Also, the full backup is scheduled for 11pm. However, the logs are getting deleted after exactly 2 days. For example, the logs...
August 12, 2011 at 10:27 am
any idea's why it would remove my log shipping logs too? How would it know where to remove them from when it's poing to a different folder than my...
August 12, 2011 at 10:01 am
No other jobs to delete my transaction log backup files. I do have a job to delete my Full backup files after 2 days. However, those are a...
August 12, 2011 at 9:48 am
Viewing 13 posts - 1 through 13 (of 13 total)