I need to restore a database over an existing DB (I have made a backup and
it's SQL 2000).
When I do try and restore it via SQL Enterprose Manager 2000 (the only way I
know) it it says "logical file 'database' is not part of a database
'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
RESTORE DATAVASE is terminating adbnormally.Use Query Analyzer and run RESTORE FILELISTONLY for the backup file. Post
those results here. We'll follow up when we get those.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Gonzo" <no@.no123.com> wrote in message
news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
I need to restore a database over an existing DB (I have made a backup and
it's SQL 2000).
When I do try and restore it via SQL Enterprose Manager 2000 (the only way I
know) it it says "logical file 'database' is not part of a database
'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
RESTORE DATAVASE is terminating adbnormally.|||I think you might have to tell it to overwrite your existing database. I
can't remember the actual steps to do it in EM, but somewhere in the
Restore wizard you have the option to "overwrite existing database" or
something like that.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Gonzo wrote:
> I need to restore a database over an existing DB (I have made a backup
> and it's SQL 2000).
> When I do try and restore it via SQL Enterprose Manager 2000 (the only
> way I know) it it says "logical file 'database' is not part of a
> database 'database2'. Use RESTORE FILELISTONLY to list the logocal file
> names. RESTORE DATAVASE is terminating adbnormally.|||Many thanks:
RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
I get:
Btest_Data C:\Program Files\Microsoft SQL Server\MSSQL\Data\BRITLIVE.mdf
D PRIMARY
Btest_Log C:\Program Files\Microsoft SQL
Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
On the server we have these DB's:
Btest
RM_test1
We sent a company the Btest DB to make some changes that they have done and
sent the bak file back. I need to restore this over the RM_test1 DB, but it
seems that it still references the original Btest DB everywhere.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file. Post
> those results here. We'll follow up when we get those.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
> I need to restore a database over an existing DB (I have made a backup and
> it's SQL 2000).
> When I do try and restore it via SQL Enterprose Manager 2000 (the only way
> I
> know) it it says "logical file 'database' is not part of a database
> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
> RESTORE DATAVASE is terminating adbnormally.
>|||Hi there, I tried that, but get the same error. I have just replied to the
other post too with a bit more info :)
""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:eOsdMVMtHHA.4888@.TK2MSFTNGP02.phx.gbl...
>I think you might have to tell it to overwrite your existing database. I
>can't remember the actual steps to do it in EM, but somewhere in the
>Restore wizard you have the option to "overwrite existing database" or
>something like that.
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator
> Gonzo wrote:
>> I need to restore a database over an existing DB (I have made a backup
>> and it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the only
>> way I know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
>> RESTORE DATAVASE is terminating adbnormally.|||From QA, run:
RESTORE DATABASE RM_test1
FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
WITH REPLACE
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Gonzo" <no@.no123.com> wrote in message
news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
Many thanks:
RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
I get:
Btest_Data C:\Program Files\Microsoft SQL Server\MSSQL\Data\BRITLIVE.mdf
D PRIMARY
Btest_Log C:\Program Files\Microsoft SQL
Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
On the server we have these DB's:
Btest
RM_test1
We sent a company the Btest DB to make some changes that they have done and
sent the bak file back. I need to restore this over the RM_test1 DB, but it
seems that it still references the original Btest DB everywhere.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file. Post
> those results here. We'll follow up when we get those.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
> I need to restore a database over an existing DB (I have made a backup and
> it's SQL 2000).
> When I do try and restore it via SQL Enterprose Manager 2000 (the only way
> I
> know) it it says "logical file 'database' is not part of a database
> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
> RESTORE DATAVASE is terminating adbnormally.
>|||Hi I get:
Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
> From QA, run:
> RESTORE DATABASE RM_test1
> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
> WITH REPLACE
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
> Many thanks:
> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
> I get:
> Btest_Data C:\Program Files\Microsoft SQL Server\MSSQL\Data\BRITLIVE.mdf
> D PRIMARY
> Btest_Log C:\Program Files\Microsoft SQL
> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>
> On the server we have these DB's:
> Btest
> RM_test1
>
> We sent a company the Btest DB to make some changes that they have done
> and
> sent the bak file back. I need to restore this over the RM_test1 DB, but
> it
> seems that it still references the original Btest DB everywhere.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a backup
>> and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the only
>> way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
>> RESTORE DATAVASE is terminating adbnormally.
>|||Type:
use master
go
... before running the RESTORE. Also, be sure that no one is connected to
the DB when you restore it.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Gonzo" <no@.no123.com> wrote in message
news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
Hi I get:
Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
> From QA, run:
> RESTORE DATABASE RM_test1
> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
> WITH REPLACE
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
> Many thanks:
> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
> I get:
> Btest_Data C:\Program Files\Microsoft SQL Server\MSSQL\Data\BRITLIVE.mdf
> D PRIMARY
> Btest_Log C:\Program Files\Microsoft SQL
> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>
> On the server we have these DB's:
> Btest
> RM_test1
>
> We sent a company the Btest DB to make some changes that they have done
> and
> sent the bak file back. I need to restore this over the RM_test1 DB, but
> it
> seems that it still references the original Btest DB everywhere.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a backup
>> and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the only
>> way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
>> RESTORE DATAVASE is terminating adbnormally.
>|||Hi
That means that somebody is using the database while you are trying to
restore it. Make sure that nobody is accessing the database - including
the session you are restoring from...:-).
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Gonzo wrote:
> Hi I get:
> Server: Msg 3101, Level 16, State 1, Line 1
> Exclusive access could not be obtained because the database is in use.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
>> From QA, run:
>> RESTORE DATABASE RM_test1
>> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> WITH REPLACE
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
>> Many thanks:
>> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> I get:
>> Btest_Data C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE.mdf
>> D PRIMARY
>> Btest_Log C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>>
>> On the server we have these DB's:
>> Btest
>> RM_test1
>>
>> We sent a company the Btest DB to make some changes that they have
>> done and
>> sent the bak file back. I need to restore this over the RM_test1 DB,
>> but it
>> seems that it still references the original Btest DB everywhere.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a
>> backup and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the
>> only way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
>> RESTORE DATAVASE is terminating adbnormally.
>>
>|||There is still a connection to the db somewhere. SOmetimes EM doesn't show
it. Do a sp_helpdb, get the dbid of the database that you're dealing with, do
a select * from master..sysprocess where dbid = <whatever the dbid is>, get
the coresponding spid and kill <spid>, then try to restore.
--
MG
"Gonzo" wrote:
> Hi I get:
> Server: Msg 3101, Level 16, State 1, Line 1
> Exclusive access could not be obtained because the database is in use.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
> > From QA, run:
> >
> > RESTORE DATABASE RM_test1
> > FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
> > WITH REPLACE
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "Gonzo" <no@.no123.com> wrote in message
> > news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
> > Many thanks:
> >
> > RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
> >
> > I get:
> >
> > Btest_Data C:\Program Files\Microsoft SQL Server\MSSQL\Data\BRITLIVE.mdf
> > D PRIMARY
> > Btest_Log C:\Program Files\Microsoft SQL
> > Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
> >
> >
> > On the server we have these DB's:
> >
> > Btest
> > RM_test1
> >
> >
> > We sent a company the Btest DB to make some changes that they have done
> > and
> > sent the bak file back. I need to restore this over the RM_test1 DB, but
> > it
> > seems that it still references the original Btest DB everywhere.
> >
> >
> > "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> > news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
> >> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
> >> Post
> >> those results here. We'll follow up when we get those.
> >>
> >> --
> >> Tom
> >>
> >> ----
> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> >> SQL Server MVP
> >> Toronto, ON Canada
> >> https://mvp.support.microsoft.com/profile/Tom.Moreau
> >>
> >>
> >> "Gonzo" <no@.no123.com> wrote in message
> >> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
> >> I need to restore a database over an existing DB (I have made a backup
> >> and
> >> it's SQL 2000).
> >>
> >> When I do try and restore it via SQL Enterprose Manager 2000 (the only
> >> way
> >> I
> >> know) it it says "logical file 'database' is not part of a database
> >> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
> >> RESTORE DATAVASE is terminating adbnormally.
> >>
> >
>|||It seems I can restore it using EM (tried on a test server) but only if i
keep the logical names. in E:\Program Files\Microsoft SQL Server\MSSQL\Data
the databse is RM_test1 but I right click on the database and go to
properties and then the tabs Data files and transaction log then the file
name is Btest_data and Btest_logs. Now a database on the live server is
already called 'Btest' will this cause a problem?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:e4XJkINtHHA.3504@.TK2MSFTNGP05.phx.gbl...
> Type:
> use master
> go
> ... before running the RESTORE. Also, be sure that no one is connected
> to
> the DB when you restore it.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
> Hi I get:
> Server: Msg 3101, Level 16, State 1, Line 1
> Exclusive access could not be obtained because the database is in use.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
>> From QA, run:
>> RESTORE DATABASE RM_test1
>> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> WITH REPLACE
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
>> Many thanks:
>> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> I get:
>> Btest_Data C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE.mdf
>> D PRIMARY
>> Btest_Log C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>>
>> On the server we have these DB's:
>> Btest
>> RM_test1
>>
>> We sent a company the Btest DB to make some changes that they have done
>> and
>> sent the bak file back. I need to restore this over the RM_test1 DB, but
>> it
>> seems that it still references the original Btest DB everywhere.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a backup
>> and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the only
>> way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
>> RESTORE DATAVASE is terminating adbnormally.
>>
>|||I now get:
Processed 9336 pages for database 'RM_test1', file 'Btest_Data' on file 1.
Processed 1 pages for database 'RM_test1', file 'Btest_Log' on file 1.
RESTORE DATABASE successfully processed 9337 pages in 13.278 seconds (5.760
MB/sec).
There is a database caleld Btest already uses Btest for it's database name
and logical name, will this create a problem with both having the same name?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:e4XJkINtHHA.3504@.TK2MSFTNGP05.phx.gbl...
> Type:
> use master
> go
> ... before running the RESTORE. Also, be sure that no one is connected
> to
> the DB when you restore it.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
> Hi I get:
> Server: Msg 3101, Level 16, State 1, Line 1
> Exclusive access could not be obtained because the database is in use.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
>> From QA, run:
>> RESTORE DATABASE RM_test1
>> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> WITH REPLACE
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
>> Many thanks:
>> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> I get:
>> Btest_Data C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE.mdf
>> D PRIMARY
>> Btest_Log C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>>
>> On the server we have these DB's:
>> Btest
>> RM_test1
>>
>> We sent a company the Btest DB to make some changes that they have done
>> and
>> sent the bak file back. I need to restore this over the RM_test1 DB, but
>> it
>> seems that it still references the original Btest DB everywhere.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a backup
>> and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the only
>> way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
>> RESTORE DATAVASE is terminating adbnormally.
>>
>|||You have to keep the logical names for the restore. You can change those
later.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Gonzo" <no@.no123.com> wrote in message
news:A4969E2E-1F25-484A-BDE3-91247145CD79@.microsoft.com...
It seems I can restore it using EM (tried on a test server) but only if i
keep the logical names. in E:\Program Files\Microsoft SQL Server\MSSQL\Data
the databse is RM_test1 but I right click on the database and go to
properties and then the tabs Data files and transaction log then the file
name is Btest_data and Btest_logs. Now a database on the live server is
already called 'Btest' will this cause a problem?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:e4XJkINtHHA.3504@.TK2MSFTNGP05.phx.gbl...
> Type:
> use master
> go
> ... before running the RESTORE. Also, be sure that no one is connected
> to
> the DB when you restore it.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
> Hi I get:
> Server: Msg 3101, Level 16, State 1, Line 1
> Exclusive access could not be obtained because the database is in use.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
>> From QA, run:
>> RESTORE DATABASE RM_test1
>> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> WITH REPLACE
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
>> Many thanks:
>> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> I get:
>> Btest_Data C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE.mdf
>> D PRIMARY
>> Btest_Log C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>>
>> On the server we have these DB's:
>> Btest
>> RM_test1
>>
>> We sent a company the Btest DB to make some changes that they have done
>> and
>> sent the bak file back. I need to restore this over the RM_test1 DB, but
>> it
>> seems that it still references the original Btest DB everywhere.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a backup
>> and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the only
>> way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
>> RESTORE DATAVASE is terminating adbnormally.
>>
>|||Use
Restore Database <db_name>
from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
WITH Move 'Btest_Data' To 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\BRITLIVE_2.mdf',
Move 'Btest_Log' To 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\BRITLIVE_2_log.ldf',
just change the name of the .mdf & .ldf to something that doesn't already
exist.
--
MG
"Gonzo" wrote:
> It seems I can restore it using EM (tried on a test server) but only if i
> keep the logical names. in E:\Program Files\Microsoft SQL Server\MSSQL\Data
> the databse is RM_test1 but I right click on the database and go to
> properties and then the tabs Data files and transaction log then the file
> name is Btest_data and Btest_logs. Now a database on the live server is
> already called 'Btest' will this cause a problem?
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:e4XJkINtHHA.3504@.TK2MSFTNGP05.phx.gbl...
> > Type:
> >
> > use master
> > go
> >
> > ... before running the RESTORE. Also, be sure that no one is connected
> > to
> > the DB when you restore it.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "Gonzo" <no@.no123.com> wrote in message
> > news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
> > Hi I get:
> >
> > Server: Msg 3101, Level 16, State 1, Line 1
> > Exclusive access could not be obtained because the database is in use.
> > Server: Msg 3013, Level 16, State 1, Line 1
> > RESTORE DATABASE is terminating abnormally.
> >
> >
> >
> >
> >
> >
> >
> >
> > "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> > news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
> >> From QA, run:
> >>
> >> RESTORE DATABASE RM_test1
> >> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
> >> WITH REPLACE
> >>
> >> --
> >> Tom
> >>
> >> ----
> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> >> SQL Server MVP
> >> Toronto, ON Canada
> >> https://mvp.support.microsoft.com/profile/Tom.Moreau
> >>
> >>
> >> "Gonzo" <no@.no123.com> wrote in message
> >> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
> >> Many thanks:
> >>
> >> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
> >>
> >> I get:
> >>
> >> Btest_Data C:\Program Files\Microsoft SQL
> >> Server\MSSQL\Data\BRITLIVE.mdf
> >> D PRIMARY
> >> Btest_Log C:\Program Files\Microsoft SQL
> >> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
> >>
> >>
> >> On the server we have these DB's:
> >>
> >> Btest
> >> RM_test1
> >>
> >>
> >> We sent a company the Btest DB to make some changes that they have done
> >> and
> >> sent the bak file back. I need to restore this over the RM_test1 DB, but
> >> it
> >> seems that it still references the original Btest DB everywhere.
> >>
> >>
> >> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> >> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
> >> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
> >> Post
> >> those results here. We'll follow up when we get those.
> >>
> >> --
> >> Tom
> >>
> >> ----
> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> >> SQL Server MVP
> >> Toronto, ON Canada
> >> https://mvp.support.microsoft.com/profile/Tom.Moreau
> >>
> >>
> >> "Gonzo" <no@.no123.com> wrote in message
> >> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
> >> I need to restore a database over an existing DB (I have made a backup
> >> and
> >> it's SQL 2000).
> >>
> >> When I do try and restore it via SQL Enterprose Manager 2000 (the only
> >> way
> >> I
> >> know) it it says "logical file 'database' is not part of a database
> >> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
> >> RESTORE DATAVASE is terminating adbnormally.
> >>
> >>
> >
>|||I have restored it now, how can I now change the logical names to something
else?
many thanks
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:O4i5xSNtHHA.3556@.TK2MSFTNGP05.phx.gbl...
> You have to keep the logical names for the restore. You can change those
> later.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:A4969E2E-1F25-484A-BDE3-91247145CD79@.microsoft.com...
> It seems I can restore it using EM (tried on a test server) but only if i
> keep the logical names. in E:\Program Files\Microsoft SQL
> Server\MSSQL\Data
> the databse is RM_test1 but I right click on the database and go to
> properties and then the tabs Data files and transaction log then the file
> name is Btest_data and Btest_logs. Now a database on the live server is
> already called 'Btest' will this cause a problem?
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:e4XJkINtHHA.3504@.TK2MSFTNGP05.phx.gbl...
>> Type:
>> use master
>> go
>> ... before running the RESTORE. Also, be sure that no one is connected
>> to
>> the DB when you restore it.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
>> Hi I get:
>> Server: Msg 3101, Level 16, State 1, Line 1
>> Exclusive access could not be obtained because the database is in use.
>> Server: Msg 3013, Level 16, State 1, Line 1
>> RESTORE DATABASE is terminating abnormally.
>>
>>
>>
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
>> From QA, run:
>> RESTORE DATABASE RM_test1
>> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> WITH REPLACE
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
>> Many thanks:
>> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> I get:
>> Btest_Data C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE.mdf
>> D PRIMARY
>> Btest_Log C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>>
>> On the server we have these DB's:
>> Btest
>> RM_test1
>>
>> We sent a company the Btest DB to make some changes that they have done
>> and
>> sent the bak file back. I need to restore this over the RM_test1 DB,
>> but
>> it
>> seems that it still references the original Btest DB everywhere.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a backup
>> and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the only
>> way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
>> RESTORE DATAVASE is terminating adbnormally.
>>
>|||No. Logical names are local to the DB.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Gonzo" <no@.no123.com> wrote in message
news:28BF2F6F-4256-4299-BE76-1F1DAAB4D61F@.microsoft.com...
I now get:
Processed 9336 pages for database 'RM_test1', file 'Btest_Data' on file 1.
Processed 1 pages for database 'RM_test1', file 'Btest_Log' on file 1.
RESTORE DATABASE successfully processed 9337 pages in 13.278 seconds (5.760
MB/sec).
There is a database caleld Btest already uses Btest for it's database name
and logical name, will this create a problem with both having the same name?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:e4XJkINtHHA.3504@.TK2MSFTNGP05.phx.gbl...
> Type:
> use master
> go
> ... before running the RESTORE. Also, be sure that no one is connected
> to
> the DB when you restore it.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
> Hi I get:
> Server: Msg 3101, Level 16, State 1, Line 1
> Exclusive access could not be obtained because the database is in use.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
>> From QA, run:
>> RESTORE DATABASE RM_test1
>> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> WITH REPLACE
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
>> Many thanks:
>> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> I get:
>> Btest_Data C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE.mdf
>> D PRIMARY
>> Btest_Log C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>>
>> On the server we have these DB's:
>> Btest
>> RM_test1
>>
>> We sent a company the Btest DB to make some changes that they have done
>> and
>> sent the bak file back. I need to restore this over the RM_test1 DB, but
>> it
>> seems that it still references the original Btest DB everywhere.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a backup
>> and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the only
>> way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
>> RESTORE DATAVASE is terminating adbnormally.
>>
>|||Check out ALTER DATABASE in the BOL.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Gonzo" <no@.no123.com> wrote in message
news:%23JzdGUNtHHA.768@.TK2MSFTNGP04.phx.gbl...
I have restored it now, how can I now change the logical names to something
else?
many thanks
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:O4i5xSNtHHA.3556@.TK2MSFTNGP05.phx.gbl...
> You have to keep the logical names for the restore. You can change those
> later.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:A4969E2E-1F25-484A-BDE3-91247145CD79@.microsoft.com...
> It seems I can restore it using EM (tried on a test server) but only if i
> keep the logical names. in E:\Program Files\Microsoft SQL
> Server\MSSQL\Data
> the databse is RM_test1 but I right click on the database and go to
> properties and then the tabs Data files and transaction log then the file
> name is Btest_data and Btest_logs. Now a database on the live server is
> already called 'Btest' will this cause a problem?
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:e4XJkINtHHA.3504@.TK2MSFTNGP05.phx.gbl...
>> Type:
>> use master
>> go
>> ... before running the RESTORE. Also, be sure that no one is connected
>> to
>> the DB when you restore it.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
>> Hi I get:
>> Server: Msg 3101, Level 16, State 1, Line 1
>> Exclusive access could not be obtained because the database is in use.
>> Server: Msg 3013, Level 16, State 1, Line 1
>> RESTORE DATABASE is terminating abnormally.
>>
>>
>>
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
>> From QA, run:
>> RESTORE DATABASE RM_test1
>> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> WITH REPLACE
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
>> Many thanks:
>> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> I get:
>> Btest_Data C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE.mdf
>> D PRIMARY
>> Btest_Log C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>>
>> On the server we have these DB's:
>> Btest
>> RM_test1
>>
>> We sent a company the Btest DB to make some changes that they have done
>> and
>> sent the bak file back. I need to restore this over the RM_test1 DB,
>> but
>> it
>> seems that it still references the original Btest DB everywhere.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a backup
>> and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the only
>> way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
>> RESTORE DATAVASE is terminating adbnormally.
>>
>|||Woudl this be it? I would have to do this for both files I guess (this is
all new to me)
ALTER DATABASE
MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...).
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23PPC$WNtHHA.4688@.TK2MSFTNGP05.phx.gbl...
> Check out ALTER DATABASE in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:%23JzdGUNtHHA.768@.TK2MSFTNGP04.phx.gbl...
> I have restored it now, how can I now change the logical names to
> something
> else?
> many thanks
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:O4i5xSNtHHA.3556@.TK2MSFTNGP05.phx.gbl...
>> You have to keep the logical names for the restore. You can change those
>> later.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:A4969E2E-1F25-484A-BDE3-91247145CD79@.microsoft.com...
>> It seems I can restore it using EM (tried on a test server) but only if i
>> keep the logical names. in E:\Program Files\Microsoft SQL
>> Server\MSSQL\Data
>> the databse is RM_test1 but I right click on the database and go to
>> properties and then the tabs Data files and transaction log then the file
>> name is Btest_data and Btest_logs. Now a database on the live server is
>> already called 'Btest' will this cause a problem?
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:e4XJkINtHHA.3504@.TK2MSFTNGP05.phx.gbl...
>> Type:
>> use master
>> go
>> ... before running the RESTORE. Also, be sure that no one is connected
>> to
>> the DB when you restore it.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
>> Hi I get:
>> Server: Msg 3101, Level 16, State 1, Line 1
>> Exclusive access could not be obtained because the database is in use.
>> Server: Msg 3013, Level 16, State 1, Line 1
>> RESTORE DATABASE is terminating abnormally.
>>
>>
>>
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
>> From QA, run:
>> RESTORE DATABASE RM_test1
>> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> WITH REPLACE
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
>> Many thanks:
>> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> I get:
>> Btest_Data C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE.mdf
>> D PRIMARY
>> Btest_Log C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>>
>> On the server we have these DB's:
>> Btest
>> RM_test1
>>
>> We sent a company the Btest DB to make some changes that they have done
>> and
>> sent the bak file back. I need to restore this over the RM_test1 DB,
>> but
>> it
>> seems that it still references the original Btest DB everywhere.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a backup
>> and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the only
>> way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
>> RESTORE DATAVASE is terminating adbnormally.
>>
>>
>|||Yep.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Gonzo" <no@.no123.com> wrote in message
news:46D17BBE-E208-4A83-942E-B7446A202C5A@.microsoft.com...
Woudl this be it? I would have to do this for both files I guess (this is
all new to me)
ALTER DATABASE
MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...).
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23PPC$WNtHHA.4688@.TK2MSFTNGP05.phx.gbl...
> Check out ALTER DATABASE in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:%23JzdGUNtHHA.768@.TK2MSFTNGP04.phx.gbl...
> I have restored it now, how can I now change the logical names to
> something
> else?
> many thanks
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:O4i5xSNtHHA.3556@.TK2MSFTNGP05.phx.gbl...
>> You have to keep the logical names for the restore. You can change those
>> later.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:A4969E2E-1F25-484A-BDE3-91247145CD79@.microsoft.com...
>> It seems I can restore it using EM (tried on a test server) but only if i
>> keep the logical names. in E:\Program Files\Microsoft SQL
>> Server\MSSQL\Data
>> the databse is RM_test1 but I right click on the database and go to
>> properties and then the tabs Data files and transaction log then the file
>> name is Btest_data and Btest_logs. Now a database on the live server is
>> already called 'Btest' will this cause a problem?
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:e4XJkINtHHA.3504@.TK2MSFTNGP05.phx.gbl...
>> Type:
>> use master
>> go
>> ... before running the RESTORE. Also, be sure that no one is connected
>> to
>> the DB when you restore it.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
>> Hi I get:
>> Server: Msg 3101, Level 16, State 1, Line 1
>> Exclusive access could not be obtained because the database is in use.
>> Server: Msg 3013, Level 16, State 1, Line 1
>> RESTORE DATABASE is terminating abnormally.
>>
>>
>>
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
>> From QA, run:
>> RESTORE DATABASE RM_test1
>> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> WITH REPLACE
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
>> Many thanks:
>> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> I get:
>> Btest_Data C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE.mdf
>> D PRIMARY
>> Btest_Log C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>>
>> On the server we have these DB's:
>> Btest
>> RM_test1
>>
>> We sent a company the Btest DB to make some changes that they have done
>> and
>> sent the bak file back. I need to restore this over the RM_test1 DB,
>> but
>> it
>> seems that it still references the original Btest DB everywhere.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a backup
>> and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the only
>> way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file names.
>> RESTORE DATAVASE is terminating adbnormally.
>>
>>
>|||Sorry about this, I'm now getting:
ALTER DATABASE RM_TEST1
MODIFY FILE (Btest_Data = logical_file_name, RM_test1_DATA =new_logical_name...).
Server: Msg 155, Level 15, State 1, Line 2
'Btest_Data' is not a recognized CREATE/ALTER DATABASE option.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:O$$Y4jNtHHA.4824@.TK2MSFTNGP06.phx.gbl...
> Yep.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:46D17BBE-E208-4A83-942E-B7446A202C5A@.microsoft.com...
> Woudl this be it? I would have to do this for both files I guess (this is
> all new to me)
> ALTER DATABASE
> MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...).
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23PPC$WNtHHA.4688@.TK2MSFTNGP05.phx.gbl...
>> Check out ALTER DATABASE in the BOL.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:%23JzdGUNtHHA.768@.TK2MSFTNGP04.phx.gbl...
>> I have restored it now, how can I now change the logical names to
>> something
>> else?
>> many thanks
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:O4i5xSNtHHA.3556@.TK2MSFTNGP05.phx.gbl...
>> You have to keep the logical names for the restore. You can change
>> those
>> later.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:A4969E2E-1F25-484A-BDE3-91247145CD79@.microsoft.com...
>> It seems I can restore it using EM (tried on a test server) but only if
>> i
>> keep the logical names. in E:\Program Files\Microsoft SQL
>> Server\MSSQL\Data
>> the databse is RM_test1 but I right click on the database and go to
>> properties and then the tabs Data files and transaction log then the
>> file
>> name is Btest_data and Btest_logs. Now a database on the live server is
>> already called 'Btest' will this cause a problem?
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:e4XJkINtHHA.3504@.TK2MSFTNGP05.phx.gbl...
>> Type:
>> use master
>> go
>> ... before running the RESTORE. Also, be sure that no one is
>> connected
>> to
>> the DB when you restore it.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
>> Hi I get:
>> Server: Msg 3101, Level 16, State 1, Line 1
>> Exclusive access could not be obtained because the database is in use.
>> Server: Msg 3013, Level 16, State 1, Line 1
>> RESTORE DATABASE is terminating abnormally.
>>
>>
>>
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
>> From QA, run:
>> RESTORE DATABASE RM_test1
>> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> WITH REPLACE
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
>> Many thanks:
>> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> I get:
>> Btest_Data C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE.mdf
>> D PRIMARY
>> Btest_Log C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>>
>> On the server we have these DB's:
>> Btest
>> RM_test1
>>
>> We sent a company the Btest DB to make some changes that they have
>> done
>> and
>> sent the bak file back. I need to restore this over the RM_test1 DB,
>> but
>> it
>> seems that it still references the original Btest DB everywhere.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a
>> backup
>> and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the
>> only
>> way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file
>> names.
>> RESTORE DATAVASE is terminating adbnormally.
>>
>>
>|||Run:
sp_helpfile
...and post the results.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Gonzo" <no@.no123.com> wrote in message
news:OKu6WmNtHHA.768@.TK2MSFTNGP04.phx.gbl...
Sorry about this, I'm now getting:
ALTER DATABASE RM_TEST1
MODIFY FILE (Btest_Data = logical_file_name, RM_test1_DATA =new_logical_name...).
Server: Msg 155, Level 15, State 1, Line 2
'Btest_Data' is not a recognized CREATE/ALTER DATABASE option.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:O$$Y4jNtHHA.4824@.TK2MSFTNGP06.phx.gbl...
> Yep.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Gonzo" <no@.no123.com> wrote in message
> news:46D17BBE-E208-4A83-942E-B7446A202C5A@.microsoft.com...
> Woudl this be it? I would have to do this for both files I guess (this is
> all new to me)
> ALTER DATABASE
> MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...).
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23PPC$WNtHHA.4688@.TK2MSFTNGP05.phx.gbl...
>> Check out ALTER DATABASE in the BOL.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:%23JzdGUNtHHA.768@.TK2MSFTNGP04.phx.gbl...
>> I have restored it now, how can I now change the logical names to
>> something
>> else?
>> many thanks
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:O4i5xSNtHHA.3556@.TK2MSFTNGP05.phx.gbl...
>> You have to keep the logical names for the restore. You can change
>> those
>> later.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:A4969E2E-1F25-484A-BDE3-91247145CD79@.microsoft.com...
>> It seems I can restore it using EM (tried on a test server) but only if
>> i
>> keep the logical names. in E:\Program Files\Microsoft SQL
>> Server\MSSQL\Data
>> the databse is RM_test1 but I right click on the database and go to
>> properties and then the tabs Data files and transaction log then the
>> file
>> name is Btest_data and Btest_logs. Now a database on the live server is
>> already called 'Btest' will this cause a problem?
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:e4XJkINtHHA.3504@.TK2MSFTNGP05.phx.gbl...
>> Type:
>> use master
>> go
>> ... before running the RESTORE. Also, be sure that no one is
>> connected
>> to
>> the DB when you restore it.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
>> Hi I get:
>> Server: Msg 3101, Level 16, State 1, Line 1
>> Exclusive access could not be obtained because the database is in use.
>> Server: Msg 3013, Level 16, State 1, Line 1
>> RESTORE DATABASE is terminating abnormally.
>>
>>
>>
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
>> From QA, run:
>> RESTORE DATABASE RM_test1
>> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> WITH REPLACE
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
>> Many thanks:
>> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> I get:
>> Btest_Data C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE.mdf
>> D PRIMARY
>> Btest_Log C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>>
>> On the server we have these DB's:
>> Btest
>> RM_test1
>>
>> We sent a company the Btest DB to make some changes that they have
>> done
>> and
>> sent the bak file back. I need to restore this over the RM_test1 DB,
>> but
>> it
>> seems that it still references the original Btest DB everywhere.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>> Post
>> those results here. We'll follow up when we get those.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>> I need to restore a database over an existing DB (I have made a
>> backup
>> and
>> it's SQL 2000).
>> When I do try and restore it via SQL Enterprose Manager 2000 (the
>> only
>> way
>> I
>> know) it it says "logical file 'database' is not part of a database
>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file
>> names.
>> RESTORE DATAVASE is terminating adbnormally.
>>
>>
>|||Hi Gonzo
You got it backwards. When the syntax shows upper case, those are the
keywords that you have to keep.
So in the following, you replace logical_file_name with YOUR logical file
name...
>> ALTER DATABASE
>> MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...).
Try this:
ALTER DATABASE RM_TEST1
MODIFY FILE (NAME = Btest_Data, NEWNAME = RM_test1_DATA)
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Gonzo" <no@.no123.com> wrote in message
news:OKu6WmNtHHA.768@.TK2MSFTNGP04.phx.gbl...
> Sorry about this, I'm now getting:
> ALTER DATABASE RM_TEST1
> MODIFY FILE (Btest_Data = logical_file_name, RM_test1_DATA => new_logical_name...).
> Server: Msg 155, Level 15, State 1, Line 2
> 'Btest_Data' is not a recognized CREATE/ALTER DATABASE option.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:O$$Y4jNtHHA.4824@.TK2MSFTNGP06.phx.gbl...
>> Yep.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:46D17BBE-E208-4A83-942E-B7446A202C5A@.microsoft.com...
>> Woudl this be it? I would have to do this for both files I guess (this
>> is
>> all new to me)
>> ALTER DATABASE
>> MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...).
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23PPC$WNtHHA.4688@.TK2MSFTNGP05.phx.gbl...
>> Check out ALTER DATABASE in the BOL.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:%23JzdGUNtHHA.768@.TK2MSFTNGP04.phx.gbl...
>> I have restored it now, how can I now change the logical names to
>> something
>> else?
>> many thanks
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:O4i5xSNtHHA.3556@.TK2MSFTNGP05.phx.gbl...
>> You have to keep the logical names for the restore. You can change
>> those
>> later.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:A4969E2E-1F25-484A-BDE3-91247145CD79@.microsoft.com...
>> It seems I can restore it using EM (tried on a test server) but only if
>> i
>> keep the logical names. in E:\Program Files\Microsoft SQL
>> Server\MSSQL\Data
>> the databse is RM_test1 but I right click on the database and go to
>> properties and then the tabs Data files and transaction log then the
>> file
>> name is Btest_data and Btest_logs. Now a database on the live server
>> is
>> already called 'Btest' will this cause a problem?
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:e4XJkINtHHA.3504@.TK2MSFTNGP05.phx.gbl...
>> Type:
>> use master
>> go
>> ... before running the RESTORE. Also, be sure that no one is
>> connected
>> to
>> the DB when you restore it.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:863AE2DE-3B3B-4647-8AC6-6BFAE4FFDDEC@.microsoft.com...
>> Hi I get:
>> Server: Msg 3101, Level 16, State 1, Line 1
>> Exclusive access could not be obtained because the database is in use.
>> Server: Msg 3013, Level 16, State 1, Line 1
>> RESTORE DATABASE is terminating abnormally.
>>
>>
>>
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23SUif2MtHHA.4796@.TK2MSFTNGP04.phx.gbl...
>> From QA, run:
>> RESTORE DATABASE RM_test1
>> FROM DISK = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> WITH REPLACE
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "Gonzo" <no@.no123.com> wrote in message
>> news:9F74A63C-2524-4AE0-AEAC-9E9853D66B30@.microsoft.com...
>> Many thanks:
>> RESTORE FILElISTONLY from Disk = 'f:\MSSQL80\BACKUP\RM_test1.bak'
>> I get:
>> Btest_Data C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE.mdf
>> D PRIMARY
>> Btest_Log C:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\BRITLIVE_log.ldf L NULL
>>
>> On the server we have these DB's:
>> Btest
>> RM_test1
>>
>> We sent a company the Btest DB to make some changes that they have
>> done
>> and
>> sent the bak file back. I need to restore this over the RM_test1 DB,
>> but
>> it
>> seems that it still references the original Btest DB everywhere.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:OUAXLKMtHHA.4572@.TK2MSFTNGP02.phx.gbl...
>>> Use Query Analyzer and run RESTORE FILELISTONLY for the backup file.
>>> Post
>>> those results here. We'll follow up when we get those.
>>>
>>> --
>>> Tom
>>>
>>> ----
>>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>>> SQL Server MVP
>>> Toronto, ON Canada
>>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>>
>>>
>>> "Gonzo" <no@.no123.com> wrote in message
>>> news:523266A9-C34C-47F9-9C22-FC91A9E798E7@.microsoft.com...
>>> I need to restore a database over an existing DB (I have made a
>>> backup
>>> and
>>> it's SQL 2000).
>>>
>>> When I do try and restore it via SQL Enterprose Manager 2000 (the
>>> only
>>> way
>>> I
>>> know) it it says "logical file 'database' is not part of a database
>>> 'database2'. Use RESTORE FILELISTONLY to list the logocal file
>>> names.
>>> RESTORE DATAVASE is terminating adbnormally.
>>>
>>
>>
>
begin 666 SQL Server 2005 BOL.lnk
M3 ````$4`@.``````P ```````$:K````( `````SFJ9/P,4!1!9#<WE3Q@.$`
M,YJF3\#%`<"N`@.```````0```````````````````)<!% `?4.!/T"#J.FD0
MHM@.(`"LP,)T9`"]#.EP`````````````````````````2@.`Q``````!]--R>
M$0!04D]'4D%^,0``,@.`#``0`[[X+,>RX?32(K!0```!0`'(`;P!G`'(`80!M
M`" `1@.!I`&P`90!S````& !(`#$``````'TT.I,0`$-/34U/3GXQ```P``,`
M! #OO@.LQ[+A]-.2L% ```$,`;P!M`&T`;P!N`" `1@.!I`&P`90!S````& !0
M`#$``````'TT6H00`$U)0U)/4WXQ```X``,`! #OO@.LQ[+A]-.2L% ```$T`
M:0!C`'(`;P!S`&\`9@.!T`" `4P!H`&$`<@.!E`&0````8`#H`,0``````?31X
M@.Q `2$5,4#A^,0`D``,`! #OOGTT:8-]-!JM% ```$@.`90!L`' `( `X````
M%@.!,`#(`P*X"`#<S*7@.@.`&1E>'!L;W)E+F5X90``, `#``0`[[XW,REX?30:
MK10```!D`&4`> !P`&P`;P!R`&4`+@.!E`'@.`90```!P```!Q````' ````$`
M```<````+0````````!P````$0````,````RQ7*P$ ````!#.EQ0<F]G<F%M
M($9I;&5S7$-O;6UO;B!&:6QE<UQ-:6-R;W-O9G0@.4VAA<F5D7$AE;' @..%QD
M97AP;&]R92YE>&4``$(`+@.`N`%P`4 !R`&\`9P!R`&$`;0`@.`$8`:0!L`&4`
M<P!<`$,`;P!M`&T`;P!N`" `1@.!I`&P`90!S`%P`30!I`&,`<@.!O`',`;P!F
M`'0`( !3`&@.`80!R`&4`9 !<`$@.`90!L`' `( `X`%P`9 !E`'@.`< !L`&\`
M<@.!E`"X`90!X`&4`; `O`&@.`90!L`' `8P!O`&P`( !M`',`+0!H`&4`; !P
M`#H`+P`O`$T`4P`N`%,`40!,`$,`0P`N`'8`.0`@.`"\`=0!S`&4`: !E`&P`
M< !S`&4`= !T`&D`;@.!G`',`( !3`%$`3 !3`&4`<@.!V`&4`<@.!"`&\`;P!K
M`',`3P!N`&P`:0!N`&4`+@.`Y`"X`, `@.`"\`3 !A`'4`;@.!C`&@.`1@.!+`&4`
M>0!W`&\`<@.!D`%0`;P!P`&D`8P`@.`',`<0!L`#D`+@.!P`&\`<@.!T`&$`; `N
M`&8`,0`0````!0``H"8```!W````8 ````,``*!8`````````&-A>F%R:6P`
M``````````!(C:U715981;/P?7->-?X;;X-("D"_VA&ZS `6;VO!>$B-K5=%
?5EA%L_!]<UXU_AMO@.T@.*0+_:$;K,`!9O:\%X````````
`
end
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment