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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2004-01-20 : 03:18:48
|
| hi all,what is the best optionfor having a backup sql server in development environment?thanksregards,harshal.He is a fool for five minutes who asks , but who does not ask remains a fool for life! |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-01-20 : 11:00:29
|
| Dump and restore to standby?What do you mean in a dev enviroment?We just dump the db nightly with tranny dumps every 4 hours...If there's a problem, then restore...(never had one since 2k though)All code should be saved with some type of change control, so it all should be able to be recreated...In additon, we've set up 2 instances on dev (1 for QA, 1 for developers)...In the case of media failure, I have a scratch pad server...but that would be in case of a prolonged outage...Why? You looking for "best practices"?Brett8-) |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-01-20 : 23:26:28
|
quote:
Originally posted by X002548
Dump and restore to standby?What do you mean in a dev enviroment?We just dump the db nightly with tranny dumps every 4 hours...If there's a problem, then restore...(never had one since 2k though)All code should be saved with some type of change control, so it all should be able to be recreated...In additon, we've set up 2 instances on dev (1 for QA, 1 for developers)...In the case of media failure, I have a scratch pad server...but that would be in case of a prolonged outage...Why? You looking for "best practices"?Brett8-)
nope looking for a standby sql server.planning to go for logshipping.we have a seperate server for QA.But they say, we need a backup server for development server in sync with the existing, so that there will be no down time.regards,harshal.He is a fool for five minutes who asks , but who does not ask remains a fool for life! |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-01-21 : 06:39:54
|
| Umm - standby dev server.Problem with dev servers is that people tend to test things like updating vast amounts of data or running volume tests. They also tend to make mistakes and have to roll back huge transactions (when they crash due to an accidental cartesian product).All these updates have to be transferred and applied to the other server which could take a long time - I hope you have a dedicated network channel between the two servers and don't share it with anything else.Completely the opposite from a company I deal with at the moment who don't even take backups but nightly saves all the dts packages, jobs and script all the tables, views and SPs (but not udf's it seems).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-01-21 : 07:26:28
|
quote:
Originally posted by nr
Umm - standby dev server.Problem with dev servers is that people tend to test things like updating vast amounts of data or running volume tests. They also tend to make mistakes and have to roll back huge transactions (when they crash due to an accidental cartesian product).All these updates have to be transferred and applied to the other server which could take a long time - I hope you have a dedicated network channel between the two servers and don't share it with anything else.Completely the opposite from a company I deal with at the moment who don't even take backups but nightly saves all the dts packages, jobs and script all the tables, views and SPs (but not udf's it seems).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.
yeah ur right.but the data we are talking about is not much as the volume tests and the crash tests are all carried on the test sql serverHe is a fool for five minutes who asks , but who does not ask remains a fool for life! |
|
|
|
|
|
|
|
|
best option