DB Restore

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
BVRPlease do not post the same message in multiple groups like this. If your
subject is relevant to > 1 Newsgroup then you can include them all on the
"To" line.
See my answer in .dts
--
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@.sbcglobal.net> wrote in message
news:uQNVLT56DHA.632@.TK2MSFTNGP12.phx.gbl...

quote:

---

> What's the best way to restore or create a copy of production db (15 GB)

---

on

quote:

---

> 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
>

---