can't find database when trying to restore

Hi I am trying to copy a complete database and did the following.
backup database, saved file at location
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
on machine 1-source machine.
I then copied this to
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
on machine two-destination machine.
I was thinking I could then use the restore from EM connected to the
destination machine but when I select restore the database name does not show
up as one of the databases that can be selected.
Thanks.
Paul G
Software engineer.
No it wont show the database in Restore database window. It will shoe only
the current database. Use have to use "From Device" option and select the bak
file from there and type the name of database.
Thanks
Ravi
"Paul" wrote:

> Hi I am trying to copy a complete database and did the following.
> backup database, saved file at location
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
> on machine 1-source machine.
> I then copied this to
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
> on machine two-destination machine.
> I was thinking I could then use the restore from EM connected to the
> destination machine but when I select restore the database name does not show
> up as one of the databases that can be selected.
> Thanks.
> --
> Paul G
> Software engineer.
|||ok thanks it worked!.
Paul G
Software engineer.
"Ravi" wrote:
[vbcol=seagreen]
> No it wont show the database in Restore database window. It will shoe only
> the current database. Use have to use "From Device" option and select the bak
> file from there and type the name of database.
>
> --
> Thanks
> Ravi
>
> "Paul" wrote:

can't find database when trying to restore

Hi I am trying to copy a complete database and did the following.
backup database, saved file at location
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
on machine 1-source machine.
I then copied this to
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
on machine two-destination machine.
I was thinking I could then use the restore from EM connected to the
destination machine but when I select restore the database name does not sho
w
up as one of the databases that can be selected.
Thanks.
--
Paul G
Software engineer.No it wont show the database in Restore database window. It will shoe only
the current database. Use have to use "From Device" option and select the ba
k
file from there and type the name of database.
Thanks
Ravi
"Paul" wrote:

> Hi I am trying to copy a complete database and did the following.
> backup database, saved file at location
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
> on machine 1-source machine.
> I then copied this to
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
> on machine two-destination machine.
> I was thinking I could then use the restore from EM connected to the
> destination machine but when I select restore the database name does not s
how
> up as one of the databases that can be selected.
> Thanks.
> --
> Paul G
> Software engineer.|||ok thanks it worked!.
--
Paul G
Software engineer.
"Ravi" wrote:
[vbcol=seagreen]
> No it wont show the database in Restore database window. It will shoe only
> the current database. Use have to use "From Device" option and select the
bak
> file from there and type the name of database.
>
> --
> Thanks
> Ravi
>
> "Paul" wrote:
>sql

can't find database when trying to restore

Hi I am trying to copy a complete database and did the following.
backup database, saved file at location
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
on machine 1-source machine.
I then copied this to
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
on machine two-destination machine.
I was thinking I could then use the restore from EM connected to the
destination machine but when I select restore the database name does not show
up as one of the databases that can be selected.
Thanks.
--
Paul G
Software engineer.No it wont show the database in Restore database window. It will shoe only
the current database. Use have to use "From Device" option and select the bak
file from there and type the name of database.
Thanks
Ravi
"Paul" wrote:
> Hi I am trying to copy a complete database and did the following.
> backup database, saved file at location
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
> on machine 1-source machine.
> I then copied this to
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
> on machine two-destination machine.
> I was thinking I could then use the restore from EM connected to the
> destination machine but when I select restore the database name does not show
> up as one of the databases that can be selected.
> Thanks.
> --
> Paul G
> Software engineer.|||ok thanks it worked!.
--
Paul G
Software engineer.
"Ravi" wrote:
> No it wont show the database in Restore database window. It will shoe only
> the current database. Use have to use "From Device" option and select the bak
> file from there and type the name of database.
>
> --
> Thanks
> Ravi
>
> "Paul" wrote:
> > Hi I am trying to copy a complete database and did the following.
> > backup database, saved file at location
> > C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
> > on machine 1-source machine.
> > I then copied this to
> > C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
> > on machine two-destination machine.
> > I was thinking I could then use the restore from EM connected to the
> > destination machine but when I select restore the database name does not show
> > up as one of the databases that can be selected.
> > Thanks.
> > --
> > Paul G
> > Software engineer.

Can't detach database

I have a database I want to copy to a second server. The
simplest way seems to be detach, copy DB & Log files,
attach.
However, I can't detach the database. When I attempt to
detach it, it says there is 1 process connected. If I
look in the management tool, there are no processes
connected.
This is a dedicated server. I shut it down, disconnected
it from the network, then restarted. The only connection
shown is the management console I am using for the detach.
But it still shows 1 connection to the database I want to
detach.
Any help is greatly appreciated.Are you by any chance the 1 user in the database?
Try directly from QA without even starting Enterprise Manager executing the
following:
USE MASTER
Go
SP_DETACH_DB YourDB
HTH,
Des
On 24/11/2004 15:27, in article 995b01c4d231$b9ccbe50$a301280a@.phx.gbl, "DB"
<anonymous@.discussions.microsoft.com> wrote:

> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.|||I've the same issue once that what i do.
First be sure that you don't have replication enabled on the database (as a
publisher or published DB)
2nd.
On EM try to dettach the DB, immediatly go to Query analyzer and run
sp_who2, look for bloking sessions,the one that is blocking should be the on
e
that is avoiding the DB to be dettahced.
This should be enough to solve the issue.
Regards.
Frivas
"DB" wrote:

> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.
>|||Make sure your Object Browser is closed, if you have it open.
"DB" <anonymous@.discussions.microsoft.com> wrote in message
news:995b01c4d231$b9ccbe50$a301280a@.phx.gbl...
> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.

Can't detach database

I have a database I want to copy to a second server. The
simplest way seems to be detach, copy DB & Log files,
attach.
However, I can't detach the database. When I attempt to
detach it, it says there is 1 process connected. If I
look in the management tool, there are no processes
connected.
This is a dedicated server. I shut it down, disconnected
it from the network, then restarted. The only connection
shown is the management console I am using for the detach.
But it still shows 1 connection to the database I want to
detach.
Any help is greatly appreciated.
Are you by any chance the 1 user in the database?
Try directly from QA without even starting Enterprise Manager executing the
following:
USE MASTER
Go
SP_DETACH_DB YourDB
HTH,
Des
On 24/11/2004 15:27, in article 995b01c4d231$b9ccbe50$a301280a@.phx.gbl, "DB"
<anonymous@.discussions.microsoft.com> wrote:

> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.
|||I've the same issue once that what i do.
First be sure that you don't have replication enabled on the database (as a
publisher or published DB)
2nd.
On EM try to dettach the DB, immediatly go to Query analyzer and run
sp_who2, look for bloking sessions,the one that is blocking should be the one
that is avoiding the DB to be dettahced.
This should be enough to solve the issue.
Regards.
Frivas
"DB" wrote:

> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.
>
|||Make sure your Object Browser is closed, if you have it open.
"DB" <anonymous@.discussions.microsoft.com> wrote in message
news:995b01c4d231$b9ccbe50$a301280a@.phx.gbl...
> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.

Can't detach database

I have a database I want to copy to a second server. The
simplest way seems to be detach, copy DB & Log files,
attach.
However, I can't detach the database. When I attempt to
detach it, it says there is 1 process connected. If I
look in the management tool, there are no processes
connected.
This is a dedicated server. I shut it down, disconnected
it from the network, then restarted. The only connection
shown is the management console I am using for the detach.
But it still shows 1 connection to the database I want to
detach.
Any help is greatly appreciated.> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--B_3184155358_1551408
Content-type: text/plain;
charset="ISO-8859-1"
Content-transfer-encoding: 8bit
Are you by any chance the 1 user in the database?
Try directly from QA without even starting Enterprise Manager executing the
following:
USE MASTER
Go
SP_DETACH_DB ?YourDB¹
HTH,
Des
On 24/11/2004 15:27, in article 995b01c4d231$b9ccbe50$a301280a@.phx.gbl, "DB"
<anonymous@.discussions.microsoft.com> wrote:
> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.
--B_3184155358_1551408
Content-type: text/html;
charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable
&

---

Re: Can't detach database
Are y=ou by any chance the 1 user in the database?
Try directly from QA without even starting Enterprise Manager executing the= following:
USE MASTER
Go
SP_DETACH_DB ‘YourDB’
HTH,
Des
On 24/11/2004 15:27, in article 995b01c4d231$b9ccbe50$a301280a@.phx.gbl, &qu=ot;DB" wrote:
> I have a database I want to copy to a second ser=ver. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
>
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
>
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
>
> But it still shows 1 connection to the database I want to
> detach.
>
> Any help is greatly appreciated.
--B_3184155358_1551408--|||I've the same issue once that what i do.
First be sure that you don't have replication enabled on the database (as a
publisher or published DB)
2nd.
On EM try to dettach the DB, immediatly go to Query analyzer and run
sp_who2, look for bloking sessions,the one that is blocking should be the one
that is avoiding the DB to be dettahced.
This should be enough to solve the issue.
Regards.
Frivas
"DB" wrote:
> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.
>|||Make sure your Object Browser is closed, if you have it open.
"DB" <anonymous@.discussions.microsoft.com> wrote in message
news:995b01c4d231$b9ccbe50$a301280a@.phx.gbl...
> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.

Can't copy/export a database with identity *NEWBIE*

I have a database where some tables have the IDENTITY = YES.
If I copy or export from ServerA to ServerB, the IDENTITY gets set to No.
This has to be a simple problem.
How is it fixed?
If you are simply doing an export/import you need to create the table with
the desired format on the subscriber/destination/target side - i.e. with the
identity property on the column. Then before you do your import set
identity_insert on for that table, i.e.
SET IDENTITY_INSERT MyTableName ONIf you are using bcp use the -E parameter.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jeffrey Brandt" <jdbrandt@.verizon.net> wrote in message
news:lO7fi.268$XH5.206@.trndny02...
>I have a database where some tables have the IDENTITY = YES.
> If I copy or export from ServerA to ServerB, the IDENTITY gets set to No.
> This has to be a simple problem.
> How is it fixed?
>
|||You were SOO right.
I ended up using snapshot replication, and pushed it to the other machine.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OBM0x%23YtHHA.1728@.TK2MSFTNGP06.phx.gbl...
> You can use queued updating subscribers or merge replication both with
> automatic identity range management.
> HTH,
> Paul Ibison
>

Can't copy databases across network with copy wizard

I am having trouble copying a database across a network using the copy database wizard.
I am receiving the following error:
'Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.'
I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated.
Regards
You would need to change the destination server to run under
a domain account. Then you need to restart SQL service.
The configuration requirements for using the copy database
wizard can be found in the following article:
INF: Understanding and Troubleshooting the Copy Database
Wizard in SQL Server 2000
http://support.microsoft.com/?id=274463
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@.discussions.microsoft.com> wrote:

>I am having trouble copying a database across a network using the copy database wizard.
>I am receiving the following error:
>'Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.'
>I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated.
>Regards
|||JackO
Sue answered you correctly. However you will have good results also if you are just willing to take the DB offline temporarily and copy over the files. Then you can attach the DB at the destination. This can be done without shutting down either server.
Jeff
|||Or...you can just backup and restore to the other server.
Nothing is offline, restarted, etc.
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@.discussions.microsoft.com> wrote:

>I am having trouble copying a database across a network using the copy database wizard.
>I am receiving the following error:
>'Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.'
>I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated.
>Regards

Can't copy databases across network with copy wizard

I am having trouble copying a database across a network using the copy database wizard
I am receiving the following error
'Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.
I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated
RegardsYou would need to change the destination server to run under
a domain account. Then you need to restart SQL service.
The configuration requirements for using the copy database
wizard can be found in the following article:
INF: Understanding and Troubleshooting the Copy Database
Wizard in SQL Server 2000
http://support.microsoft.com/?id=274463
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@.discussions.microsoft.com> wrote:
>I am having trouble copying a database across a network using the copy database wizard.
>I am receiving the following error:
>'Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.'
>I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated.
>Regards|||Or...you can just backup and restore to the other server.
Nothing is offline, restarted, etc.
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@.discussions.microsoft.com> wrote:
>I am having trouble copying a database across a network using the copy database wizard.
>I am receiving the following error:
>'Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.'
>I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated.
>Regards

Can't copy databases across network with copy wizard

I am having trouble copying a database across a network using the copy datab
ase wizard.
I am receiving the following error:
'Your SQL Server Service is running under the local system account. You need
to change your SQL Server Service account to have the rights to copy files
over the network.'
I have gone into services and set up the appropriate account to log unto the
network servers with system admin priviledges but this does not solve the p
roblem. Any step by step help would be appreciated.
RegardsYou would need to change the destination server to run under
a domain account. Then you need to restart SQL service.
The configuration requirements for using the copy database
wizard can be found in the following article:
INF: Understanding and Troubleshooting the Copy Database
Wizard in SQL Server 2000
http://support.microsoft.com/?id=274463
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@.discussions.microsoft.com> wrote:

>I am having trouble copying a database across a network using the copy data
base wizard.
>I am receiving the following error:
>'Your SQL Server Service is running under the local system account. You nee
d to change your SQL Server Service account to have the rights to copy files
over the network.'
>I have gone into services and set up the appropriate account to log unto th
e network servers with system admin priviledges but this does not solve the
problem. Any step by step help would be appreciated.
>Regards|||JackO
Sue answered you correctly. However you will have good results also if you
are just willing to take the DB offline temporarily and copy over the files.
Then you can attach the DB at the destination. This can be done without s
hutting down either server.
Jeff|||Or...you can just backup and restore to the other server.
Nothing is offline, restarted, etc.
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@.discussions.microsoft.com> wrote:

>I am having trouble copying a database across a network using the copy data
base wizard.
>I am receiving the following error:
>'Your SQL Server Service is running under the local system account. You nee
d to change your SQL Server Service account to have the rights to copy files
over the network.'
>I have gone into services and set up the appropriate account to log unto th
e network servers with system admin priviledges but this does not solve the
problem. Any step by step help would be appreciated.
>Regards

Cant copy database, strange error

I'm trying to copy a database from my web host to local Sql Server 2005 instance using the Copy Database wizard. I get this error:

An exception occurred while executing a Transact-SQL statement or batch.

Server user 'celestine' is not a valid user id database 'db2'.

However, 'db2' isn't the database I was trying to copy! I am trying to copy db1, but this error is complaining about db2, which is in fact somebody else's database that I don't have a login for. Why am I getting an error about db2 when I'm not trying to do anything with db2?

I can however export the tables from db1 just fine using Export. But then I have to go back and generate script to re-create the stored procs, views, etc., so it is rather tedious to do it that way.

This may be possible. For example if there is a view in db1 which references a table in db2, and the celestine login does not have access to db2, you may encounter this error.

So to avoid such issue, you can move/copy database by taking a full backup of the source database and then restore it on the destination server.

|||

Good idea but -- No, this is not the case. This is a shared hosting situation, the 2nd database is owned by someone else, I have absolutely no access to it at all. There is no relationship whatsoever between the databases.

I can't do a backup/restore either because I don't have access to the remote filesystem.

|||

Urgh...that's really a trouble. Then check whether your login has sufficient permissions to perform copy database task:

Required permissions

For the Copy Database Wizard to work, you must have the correct permissions, depending on how you are copying the database, as follows:

For the Detach and Attach Method, you must be a member of thesysadmin fixed server role on the both source and destination servers.

|||Right. But a) I do have correct permissions for both source/destination for the database I'm trying to copy, and b) The error is not pertaining to the database I want to copy. The error mentions a different database, that I have zero permissions for, that I will never have permissions for, that I don't want permissions for. I am trying to copy db1 and the error says "you don't have permissions for db2". Why is it even checking anything for db2?

Can't copy a database

I want to make a working copy of a database to a new name on the same server. I use the wizard giving the same name for source and destination, but giving the db copy a new name. I get an error that says "One or m ore arguments are invalid."

But no hint as to what is wrong.

Is it that I can't copy on the same machine?

You want to do a 'backup database' and 'restore database' to create a new database based on the old database.

Here is a script that you can use.

use master
go
declare @.db1 sysname,@.db2 sysname,
@.name1 sysname, @.name2 sysname,
@.file1 sysname,@.file2 sysname,
@.sql nvarchar(1000)

set @.db1='Northwind'
set @.db2='NewBD'

set @.sql='select @.name1=name,@.file1=filename from '+@.db1+'..sysfiles where fileid=1'
exec sp_executesql @.sql,N'@.name1 sysname out,@.file1 sysname out',@.name1 out,@.file1 out

set @.sql='select @.name2=name,@.file2=filename from '+@.db1+'..sysfiles where fileid=2'
exec sp_executesql @.sql,N'@.name2 sysname out,@.file2 sysname out',@.name2 out,@.file2 out

select @.name1=ltrim(rtrim(@.name1)),
@.name2=ltrim(rtrim(@.name2)),
@.file1=substring(@.file1,1,(len(@.file1)-charindex('\',reverse(rtrim(@.file1)))))+'\'+@.db2+'.mdf',
@.file2=substring(@.file2,1,(len(@.file2)-charindex('\',reverse(rtrim(@.file2)))))+'\'+@.db2+'.ldf'

set @.sql='backup database '+@.db1+' to disk=''c:\db1.tmp'' with init'
exec master..sp_executesql @.sql

set @.sql='restore database '+@.db2+' from disk=''c:\db1.tmp''
with replace,
move '+quotename(@.name1,char(39))+' to '+quotename(@.file1,char(39))+',
move '+quotename(@.name2,char(39))+' to '+quotename(@.file2,char(39))+',
recovery'

exec master..sp_executesql @.sql|||

I will give this a try. Thanks!

(But one wonders why simple stuff like this can't be handled by the GUI.)

Can't connect to Access project

I've given a copy of Access project to user (win2000prof) but not able to
connect to SQL server on remote server.
SQL driver in use on client is 3.70.09.61 - this gives error DBNMPNTM
specified SQL server not found.
On my PC ( XP and SQL driver 2000.85.1117.00 ) it connects with same login
details.
Can I just download updated version or do I need SQL client software
installed on PC?
Thanks
Try updating the MDAC version on the Windows 2000 client.
You can verify MDAC versions with the component checker. You
can download component checker and MDAC versions from:
http://msdn.microsoft.com/data/mdac/...s/default.aspx
-Sue
On Tue, 9 Aug 2005 07:21:04 -0700, lindab
<lindab@.discussions.microsoft.com> wrote:

>I've given a copy of Access project to user (win2000prof) but not able to
>connect to SQL server on remote server.
>SQL driver in use on client is 3.70.09.61 - this gives error DBNMPNTM
>specified SQL server not found.
>On my PC ( XP and SQL driver 2000.85.1117.00 ) it connects with same login
>details.
>Can I just download updated version or do I need SQL client software
>installed on PC?
>Thanks