sql server programming: We have a 200 gig prod. database, I need to refresh this
db on the dev. server. Dev. box has a space limitation
of 50 gig. My question is how to refresh big db's in dev.
boxes.

Any help is greatly appreciated.

Hi

You don't say if this includes the log file or not? It is always best to
have sufficient capacity on the dev server to accommodate the live database
(or even several copies!) as working on your live server could be dangerous!
Even working on a copy of the live database on the live server couild
potentially cause problems (for example if you deleted data from the wrong
database!).

Ideally you should also have the capacity to do performance testing on
actual volumes.


John

[quoted text, click to view]