What's the best way to restore or create a copy of production db (15 GB) on
development server and also another copy on same sql server with different
name.

The copies need to be refreshed on a monthly basis.

1. For doing above things what's best and can some one post sctips or TSQL
statements to do so...

2. what's the importance of move statement in a restore?

Thanks
BVR

BACKUP/ RESTORE works for me. You can do the backup online so no disruption
to the users.
sp_detach_db and sp_detach_db are good also but involves taking the source
offline.
MOVE statement simply tells SQL Server to place the files for the database
in a specific location on disk.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Uhway" <vbhadharla (AT) sbcglobal (DOT) net> wrote

for the second sp_detach_db i meant to say sp_attach_db

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

who can tell me some free newsgroup server?
Thanks
"Uhway" <vbhadharla (AT) sbcglobal (DOT) net> дÈëÏûÏ¢ÐÂÎÅ
:ewRwqT56DHA.1368 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

what's wrong with msnews.microsoft.com ?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"NorthSky" <ju_feng (AT) 163 (DOT) net> wrote

On Wed, 11 Feb 2004 16:47:09 +0800, "NorthSky" wrote:

http://news.individual.net/
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander