DB Maintenance Plan

I have a SQL 2000 server that has a small but very important database (about 5GB). The current maintenance plan does trans logs every hour and full every day. Currently they are to file on the same drive array. I would like to send them to a share on another server just to be really safe.

Would it be better to

1. Redirect the maintenance plan so that trans logs and backups go directly to the share

or

2. Keep the maintenance plan back ups to the current location and write a script that runs every hour and copies the .bak files to the share.

Also, since the database is so small should I just do full backups every hour instead of transaction?

Hi,

assuming your DB recovery model is full , perform T-Log backup on hourly interval and daily differential backup and weekly full backup....

but ultimately its upto your requirement performing T-Log backup regularly will helps you recover point in time.

Regards

Hemantgiri S. Goswami

|||

Thanks for the tip regarding backup types.

What about getting the backups off of the SQL server? Should I redirect them during the backup process or should I let them go to a local drive and them copy them elsewhere?

|||

Hi,

Copy them on Network after taking backup on local drive. The reason is suppose their is a network congession or slow network connection while you taking backup dirctly on Network Drive you may get poor response and might be fails to write backup.

Refer below links for more

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=936771&SiteID=1

http://searchsqlserver.techtarget.com/featuredTopic/0,290042,sid87_gci1144141,00.html

http://www.lazydba.com/sql/1__849.html

http://www.windowsitpro.com/Article/ArticleID/14025/14025.html

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6096

HTH

Hemantgiri S. Goswami