"jerryk" <noone@nowhere.com> wrote in message
news:e9I3ZHQ7EHA.208@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I need to make a copy for testing purposes of the a live database. I am
not
> concerned that my data is completely accurate, ie. can handle seeing a
> transaction in action. The one thing I cannot do is detach the database,
> since the database is operational 7 X 24. Any thoughts on the best way to
> accomplish this task?
>
> Thanks,
>
> Jerry
>
>

"jerryk" <noone@nowhere.com> wrote in message
news:e9I3ZHQ7EHA.208@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I need to make a copy for testing purposes of the a live database. I am
> not
> concerned that my data is completely accurate, ie. can handle seeing a
> transaction in action. The one thing I cannot do is detach the database,
> since the database is operational 7 X 24. Any thoughts on the best way to
> accomplish this task?
>
> Thanks,
>
> Jerry
>
>

"Sunny" <sunny_1178@hotmail.com> wrote in message
news:e3FMrRR7EHA.3684@TK2MSFTNGP10.phx.gbl...
> Create DTS package. See help for more details of DTS.
> "jerryk" <noone@nowhere.com> wrote in message
> news:e9I3ZHQ7EHA.208@TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I need to make a copy for testing purposes of the a live database. I am
> not
> > concerned that my data is completely accurate, ie. can handle seeing a
> > transaction in action. The one thing I cannot do is detach the
database,
> > since the database is operational 7 X 24. Any thoughts on the best way
to
> > accomplish this task?
> >
> > Thanks,
> >
> > Jerry
> >
> >
>
>