Restoring SQL 2000 database to another SQL Server

I get all sorts of errors using this:
RESTORE DATABASE TMW_LIVE FROM disk
= '\\lbtsql\sqlbackup\backup\tmw_live_db_200307010100.bak'
WITH MOVE 'psmaster52data' TO 'c:\program files\ms sql
server\mssql\data\tmw_live.mdf',
MOVE 'psmaster52log' to 'c:\program files\ms sql
server\mssql\data\tmw_live.ldf',
REPLACE
go
Couple of questions: my database's name is TMW_LIVE and
the logical name is psmaster52data - am I using them in
the correct spot? I get an error saying that the physical
name tmw_live.mdf may be incorrect - that is where I want
to restore to, how can it be incorrect? I've tried it
with a database named this and then deleted it. I also
get an error saying: "File 'psmaster52Data' cannot be
restored to 'c:\program ..." use MOVE instead. I was
using move. All I'm trying to do is to take a backup on
one SQL Server and restore to another (that doesn't have
the same drives), can anyone help me out on this?Larry,
Make sure that there's no files with the same name in that directory where
you're trying to restore the database. This is usually the cause of the
"File 'psmaster52Data' cannot be restored to 'c:\program ...' use MOVE
instead" error.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Larry Shulan" <lshulan@.lindencompanies.com> wrote in message
news:060b01c33fdc$d4df12d0$a001280a@.phx.gbl...
> I get all sorts of errors using this:
> RESTORE DATABASE TMW_LIVE FROM disk
> = '\\lbtsql\sqlbackup\backup\tmw_live_db_200307010100.bak'
> WITH MOVE 'psmaster52data' TO 'c:\program files\ms sql
> server\mssql\data\tmw_live.mdf',
> MOVE 'psmaster52log' to 'c:\program files\ms sql
> server\mssql\data\tmw_live.ldf',
> REPLACE
> go
> Couple of questions: my database's name is TMW_LIVE and
> the logical name is psmaster52data - am I using them in
> the correct spot? I get an error saying that the physical
> name tmw_live.mdf may be incorrect - that is where I want
> to restore to, how can it be incorrect? I've tried it
> with a database named this and then deleted it. I also
> get an error saying: "File 'psmaster52Data' cannot be
> restored to 'c:\program ..." use MOVE instead. I was
> using move. All I'm trying to do is to take a backup on
> one SQL Server and restore to another (that doesn't have
> the same drives), can anyone help me out on this?

Restoring Master Database errors on SQL 2000 SP3a

Hi All
I work in a envoriment where i restore lots of master
database for specfic reason.
The problem i am currently encountering is the following
When i attempt to restore the Master database is SQL
Enterprise Manager (in single user mode) i get a error
box with a title of sql-dmo odbc sqlstate: HY000 and
nothing else.
It then kills the SQL service which i can then restart as
normal but the master database is not restored.
If i attempt to restore via SQL Query Anylzer i just get
connect broken and the SQL service is stopped.
The only way i have found to restore my master database is
to reinstall SQL from scratch which is very time consuming.
Has anyone else seen this and now how to workaround this
issue with out reinstalling SQL
Many Thanks
Martin Cheetham
Hi,
I have never ended up in this situation. I recommend you to try rebuilding
the MASTER database using REBUILDM.EXE rather than reinstalling SQL Server.
After rebulding the master you can restore the database
using the normal procedure
Thanks
Hari
MCDBA
"Martin Cheetham" <martin_cheetham@.yahoo.co.uk> wrote in message
news:237a101c45e86$4c7f5b60$a401280a@.phx.gbl...
> Hi All
> I work in a envoriment where i restore lots of master
> database for specfic reason.
> The problem i am currently encountering is the following
> When i attempt to restore the Master database is SQL
> Enterprise Manager (in single user mode) i get a error
> box with a title of sql-dmo odbc sqlstate: HY000 and
> nothing else.
> It then kills the SQL service which i can then restart as
> normal but the master database is not restored.
> If i attempt to restore via SQL Query Anylzer i just get
> connect broken and the SQL service is stopped.
> The only way i have found to restore my master database is
> to reinstall SQL from scratch which is very time consuming.
> Has anyone else seen this and now how to workaround this
> issue with out reinstalling SQL
> Many Thanks
> Martin Cheetham

Restoring Master Database errors on SQL 2000 SP3a

Hi All
I work in a envoriment where i restore lots of master
database for specfic reason.
The problem i am currently encountering is the following
When i attempt to restore the Master database is SQL
Enterprise Manager (in single user mode) i get a error
box with a title of sql-dmo odbc sqlstate: HY000 and
nothing else.
It then kills the SQL service which i can then restart as
normal but the master database is not restored.
If i attempt to restore via SQL Query Anylzer i just get
connect broken and the SQL service is stopped.
The only way i have found to restore my master database is
to reinstall SQL from scratch which is very time consuming.
Has anyone else seen this and now how to workaround this
issue with out reinstalling SQL
Many Thanks
Martin CheethamHi,
I have never ended up in this situation. I recommend you to try rebuilding
the MASTER database using REBUILDM.EXE rather than reinstalling SQL Server.
After rebulding the master you can restore the database
using the normal procedure
--
Thanks
Hari
MCDBA
"Martin Cheetham" <martin_cheetham@.yahoo.co.uk> wrote in message
news:237a101c45e86$4c7f5b60$a401280a@.phx.gbl...
> Hi All
> I work in a envoriment where i restore lots of master
> database for specfic reason.
> The problem i am currently encountering is the following
> When i attempt to restore the Master database is SQL
> Enterprise Manager (in single user mode) i get a error
> box with a title of sql-dmo odbc sqlstate: HY000 and
> nothing else.
> It then kills the SQL service which i can then restart as
> normal but the master database is not restored.
> If i attempt to restore via SQL Query Anylzer i just get
> connect broken and the SQL service is stopped.
> The only way i have found to restore my master database is
> to reinstall SQL from scratch which is very time consuming.
> Has anyone else seen this and now how to workaround this
> issue with out reinstalling SQL
> Many Thanks
> Martin Cheetham

Restoring Master Database errors on SQL 2000 SP3a

Hi All
I work in a envoriment where i restore lots of master
database for specfic reason.
The problem i am currently encountering is the following
When i attempt to restore the Master database is SQL
Enterprise Manager (in single user mode) i get a error
box with a title of sql-dmo odbc sqlstate: HY000 and
nothing else.
It then kills the SQL service which i can then restart as
normal but the master database is not restored.
If i attempt to restore via SQL Query Anylzer i just get
connect broken and the SQL service is stopped.
The only way i have found to restore my master database is
to reinstall SQL from scratch which is very time consuming.
Has anyone else seen this and now how to workaround this
issue with out reinstalling SQL
Many Thanks
Martin CheethamHi,
I have never ended up in this situation. I recommend you to try rebuilding
the MASTER database using REBUILDM.EXE rather than reinstalling SQL Server.
After rebulding the master you can restore the database
using the normal procedure
Thanks
Hari
MCDBA
"Martin Cheetham" <martin_cheetham@.yahoo.co.uk> wrote in message
news:237a101c45e86$4c7f5b60$a401280a@.phx
.gbl...
> Hi All
> I work in a envoriment where i restore lots of master
> database for specfic reason.
> The problem i am currently encountering is the following
> When i attempt to restore the Master database is SQL
> Enterprise Manager (in single user mode) i get a error
> box with a title of sql-dmo odbc sqlstate: HY000 and
> nothing else.
> It then kills the SQL service which i can then restart as
> normal but the master database is not restored.
> If i attempt to restore via SQL Query Anylzer i just get
> connect broken and the SQL service is stopped.
> The only way i have found to restore my master database is
> to reinstall SQL from scratch which is very time consuming.
> Has anyone else seen this and now how to workaround this
> issue with out reinstalling SQL
> Many Thanks
> Martin Cheetham