Is it possiable to just backup the SQL Server 2005 db's [archive, publishing,
reporting, draft] from Production and restore them in a Testing Instance to
db's [archiveT, publishingT, reportingT, draftT] to have a mirror image if
you will.

--
Project Consultant

Project Server Training Site
http://moss.rejcompany.com:30778/pwat

Hi Robert,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP


Robert wrote:
> Is it possiable to just backup the SQL Server 2005 db's [archive,
> publishing, reporting, draft] from Production and restore them in a
> Testing Instance to db's [archiveT, publishingT, reportingT, draftT]
> to have a mirror image if you will.

Robert,

Yes, it is possible. You just have to change the name of the database in the
dialog box while doing the restore.
If you are doing this backup-restore very often, you could write a stored
procedure in SQL Server which will do that.

Gérard Ducouret


"Robert" <rob@rejcompany.com> a écrit dans le message de news:
3D9C2BF3-4181-4569-830A-29DDEA0B3BD0@microsoft.com...
> Is it possiable to just backup the SQL Server 2005 db's [archive,
> publishing,
> reporting, draft] from Production and restore them in a Testing Instance
> to
> db's [archiveT, publishingT, reportingT, draftT] to have a mirror image if
> you will.
>
> --
> Project Consultant
>
> Project Server Training Site
> http://moss.rejcompany.com:30778/pwat