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:
> 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.
> >|||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.googlegroups.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:
>> 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.
>> >
>