January 10, 2007 at 3:05 am
Hi,
I am working for a product based company and we follow weekly minor builds and Major Build in Every 45-60 Days. and the SQL Objects (Sproc,Function,Trigger etc) and DDL & DMLs will be bundled in a Scrit file for each of teh major/Minor Builds. and will be updated in teh production Servers in a Sequence once in a month. now i am looking for a tool to do this updation for me. is there any thing you guys use or is there any better method to update production DBs ??. Pls help.
Jeswanth
--------------------------------
January 10, 2007 at 3:54 am
Hi,
What type of environment you have like is it OLTP type? There are so many Tools available in SQL Server as
1. Use Backup / Restore you can always create a maintananace plan to take Full database backup as well as Tlog backup periodecally depending on your scenario.
2. Logshipping to ship the log to different box for more safety.
3. Use Cluster
4. Replications.
Please check the below links for more information.
http://support.microsoft.com/kb/307775/en-us
http://support.microsoft.com/kb/822400/en-us
Check BOL also
Minaz Amin
"More Green More Oxygen !! Plant a tree today"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply