Very Computer

by **Maria Thomadaki** » Sat, 27 Apr 2002 00:00:06

Hi,

I am trying to create a weekly job which restores two databases: one from
production to test and another test db on the same test server. To
accomplish the first task, I'm using the sp_attach_db procedure but I'm
having difficulty with an aspect of this - please see below.

from a backup the physical name obviously changes. How do I declare this as
a variable and just use the variable in the script?

Sorry for the juvenile question but I'm new to this.

Thanks,

Maria

by **<msnews.microsoft.com>** » Sat, 27 Apr 2002 00:40:10

Your process is uncelare to me but to answer your question, just declare a
variable and set it to the expected name and pass it into the sp as a
parameter.

convert(varchar, getdate(), 112) + '.mdf')

Keep in mind the file you attach can't be a backup file from the backup
database command. It needs to be a valid DataBase file. . .

> Hi,

> I am trying to create a weekly job which restores two databases: one from
> production to test and another test db on the same test server. To
> accomplish the first task, I'm using the sp_attach_db procedure but I'm
> having difficulty with an aspect of this - please see below.

> exec sp_attach_db db = N'db_copy',

weekly
> from a backup the physical name obviously changes. How do I declare this
as
> a variable and just use the variable in the script?

> Sorry for the juvenile question but I'm new to this.

> Thanks,

> Maria

by **Puneet Parasha** » Sat, 27 Apr 2002 04:23:50

Hi,

Be careful with sp_attach_db, as it requiremetns are much higher.

The better approach is to backup the database and restore it on the
another server.

Thanks,
Puneet

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!