December 6, 2006 at 3:34 am
Hi
When a create a maintenance plan with the wizard, I'm asked the ffw question which I dont understand completely:
"Backup the database as part of the maintenance plan": This is a full backup, isn't it?
"Backup the transaction log as part of the maintenance plan": Although I do not want rely on the transaction log backups (the db is quite small and I have a full db backup every few hours) I guess that this is a must in order to avoid it from growing endless. Is this right?
In case of a restore the use of the existing transaction log and the existing transaction log backups is optionally. Is this right?
Many thanks
Thomas
December 6, 2006 at 11:26 am
When you are creating maintenance plan it will ask you for database backup..."Specify the Database Bakcup Plan" tab is for full backup "Specify the Transaction Log Bakcup Plan" tab is for Tlog backup.
You can configure as you wish.. obviously you have to the full backup so you should check that option where for tlog it is upto your business needs.. if you guys don't worry about point in time recovery then you don't need to backup but you should change your database recovery model to SIMPLE.
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 12:35 pm
If your recovery mode is FULL, you need to do both the full backup and the transaction log backup. If you don't do the log backups, your log file will grow and keep growing. If you don't need the log files for restoring, switch your recovery mode to SIMPLE.
-SQLBill
December 11, 2006 at 3:36 am
Hi
Thanks for your reply.
Just to be sure: This means, the Logfile is not truncated on so called full backup. Is that right?
Regards
Thomas
December 11, 2006 at 12:09 pm
Yes, that is correct...
Log file will not be truncated when you run the full backup...
MohammedU
Microsoft SQL Server MVP
December 11, 2006 at 4:35 pm
However, if you don't care about the log file...set your recovery mode to simple. Then SQL Server checkpoints the log file and truncates it. This way you don't have to do log backups.
-SQLBill
December 11, 2006 at 4:48 pm
Can you setup a maintenance plan and tell it to backup to a network share?
or can that only be done through a script?
December 11, 2006 at 4:55 pm
Both ways it can be done..
MohammedU
Microsoft SQL Server MVP
December 11, 2006 at 5:16 pm
I don't seem to be able to specify a network path when choosing a location.
Something I am missing?
This is in the maintenance plan wizard walkthrough.
December 12, 2006 at 10:01 am
On the tab for Complete Backup, look near the bottom, there should be a place to enter the location for the backup. You have to check the 'radio button' (the round circle) for 'Use this directory'. Then enter the path.
-SQLBill
December 12, 2006 at 2:56 pm
I believe you need to type the path...
ex: \\servername\c$\foldername\
MohammedU
Microsoft SQL Server MVP
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply