Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2008-04-07 : 07:36:17
|
| DB Maintenance Plan 1I'm Log Shipping from our production server to a backup server that we use to run reports against. The logs are shipped every 15 minutes throughout the day.DB Maintenance Plan 2I perform a full database dump every night. Do I also need to back the transaction logs in this maintenance plan?My guess is yes but it seems redundant and will cause additional resource utilization for the server.Thanks,Terry |
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2008-04-07 : 08:44:10
|
| I have answered my own question. The answer is No.The way I checked is by right-clicking the database and selecting Restore. The window that popped up displayed the last full backup from DB maintenance plan 2 plus all the logs since. The location the logs would restore from is the same location as the Log Shipping logs from DB maintenance plan 1 (C:\LS_Logs).Thanks,Terry |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-07 : 09:21:05
|
| Ok |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-07 : 13:19:38
|
| Well actually if you backed up the transaction logs outside of the log shipping maintenance plan, you would break log shipping.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
mchampse
Starting Member
4 Posts |
Posted - 2008-04-09 : 21:13:40
|
| Does a backup of the transaction log automatically do a truncation? I am working with a database with a default database maintenance plan and the t-log is huge even though there are hourly backups of the t-log. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 21:39:35
|
| you must be doing huge logged operation like1)bulk-insert2)Rebuild index3) Massive deleteTry to shrink it with DBCC Shrinkfile. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-09 : 21:39:41
|
| It truncates the completed transactions.How much is in use inside the tlog? You probably have a ton of free space inside the file. Do you also have an optimizations job? If so, how big is the used portion in the MDF file? And how big is the LDF file?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 21:40:36
|
Tara,Here is technical echo i can hear. |
|
|
|
|
|
|
Transaction Logs