best way to set up development and test databases

Hi,
I would like to set up 2 copies of my database - one as a development
database and another for testing.
I have tried to use the Transfer database option but it fails consistently.
Could I simply backup my "live" database and restore it onto a blank database.
Yes.
"lindab" <lindab@.discussions.microsoft.com> wrote in message
news:133A5514-D004-4187-B3F6-CD6F724AA5D9@.microsoft.com...
> Hi,
> I would like to set up 2 copies of my database - one as a development
> database and another for testing.
> I have tried to use the Transfer database option but it fails
> consistently.
> Could I simply backup my "live" database and restore it onto a blank
> database.
>
|||If on the same machine, be sure & use the "with move" option on the
restore, so you have different mdf & ldf filenames for the OS to work
with.
ChrisR wrote:[vbcol=seagreen]
> Yes.
> "lindab" <lindab@.discussions.microsoft.com> wrote in message
> news:133A5514-D004-4187-B3F6-CD6F724AA5D9@.microsoft.com...
|||The same would apply if on different machines, and SQL was installed in a
different location.
<unc27932@.yahoo.com> wrote in message
news:1123608429.243967.43720@.g44g2000cwa.googlegro ups.com...
> If on the same machine, be sure & use the "with move" option on the
> restore, so you have different mdf & ldf filenames for the OS to work
> with.
> ChrisR wrote:
>