Restored database in loading mode.

I tried to restore a dump database to a newly created
database.After it prompts the msg that the database has
beem successfully restored, in the Enterprise Manager, the
database (the restored database) is on the loading mode.
Is there any solution for this.
The data is running on SQL 2000(service pack 3A) in Win
Server 2003.
Pls advise.
Thanks.Seems like you forgot to do the Recovery. Check the "Recovering a Database
Without Restoring" topic in Books OnLine
(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\ad
minsql.chm::/ad_bkprst_4zc7.htm).
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Ash'" <sukli@.hotmail.com> wrote in message
news:0c1101c38afb$e92d4b70$a401280a@.phx.gbl...
> I tried to restore a dump database to a newly created
> database.After it prompts the msg that the database has
> beem successfully restored, in the Enterprise Manager, the
> database (the restored database) is on the loading mode.
> Is there any solution for this.
> The data is running on SQL 2000(service pack 3A) in Win
> Server 2003.
> Pls advise.
> Thanks.|||In addition to Dejans message when you restore a database it is unavailable
(loading) while you restore the differential and all of the transaction
logs. When you have completed the restore, you run recovery will rolls back
incomplete transactions and makes the database available.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ash'" <sukli@.hotmail.com> wrote in message
news:0c1101c38afb$e92d4b70$a401280a@.phx.gbl...
> I tried to restore a dump database to a newly created
> database.After it prompts the msg that the database has
> beem successfully restored, in the Enterprise Manager, the
> database (the restored database) is on the loading mode.
> Is there any solution for this.
> The data is running on SQL 2000(service pack 3A) in Win
> Server 2003.
> Pls advise.
> Thanks.

Restore Problem (6.5)

I need to restore a SQL 6.5 database dump onto my laptop. Unfortunately I
don't have enought disk space, so work has kindly provided a USB external
hard disk. I can create the device on that disk, but what I try and restore
the database. It comes up with a 'Unable to write to server-side connection'
error message.
Any ideas ?
Cheers
MarkHi,
After creating the device , did you tried creating the database. The size
should be identical to the source database from where you received the dump
file.
Give me more information about,
1. Location of Dump file
2. Are you able to see the logical drives (newly attached external disk)
from explorer?
If you still have issues , try creating a table on the new database created.
Thanks
Hari.
MCDBA
"Flems" <Mark.Flemans@.apakgroup.com> wrote in message
news:uLYdnMXvDHA.1788@.tk2msftngp13.phx.gbl...
> I need to restore a SQL 6.5 database dump onto my laptop. Unfortunately I
> don't have enought disk space, so work has kindly provided a USB external
> hard disk. I can create the device on that disk, but what I try and
restore
> the database. It comes up with a 'Unable to write to server-side
connection'
> error message.
> Any ideas ?
> Cheers
> Mark
>

restore master problem

When i try to restore master db with
sqlservr -c -m -T4022
ISQL -E , restore database master from device='d:\dump\masterdump.dat'
restore fail with message
Error: 3151, Severity: 21, State: 0.
Error: 9001, Severity: 21, State: 1.
and sqlserver terminated..
I have try this.
1. backup a new masterdump from other sqlserver b and and restore to server
a .. same problem
2. take this masterdump from server b and restore to other server, sucessful.
3. backup master from sqlserver(a) and restore to sqlserver(a) succesful.
i using sqlserver sp3
win2003 standard edition..
any suggestion?Hi,
Did you try rebuilding the master with rebuildm utlility and then try to
restore again?
--
Danijel Novak
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:3184264F-DC6F-4A12-B8B9-E7F8C508B14A@.microsoft.com...
> When i try to restore master db with
> sqlservr -c -m -T4022
> ISQL -E , restore database master from device='d:\dump\masterdump.dat'
> restore fail with message
> Error: 3151, Severity: 21, State: 0.
> Error: 9001, Severity: 21, State: 1.
> and sqlserver terminated..
> I have try this.
> 1. backup a new masterdump from other sqlserver b and and restore to
> server
> a .. same problem
> 2. take this masterdump from server b and restore to other server,
> sucessful.
> 3. backup master from sqlserver(a) and restore to sqlserver(a) succesful.
> i using sqlserver sp3
> win2003 standard edition..
> any suggestion?
>

restore master problem

When i try to restore master db with
sqlservr -c -m -T4022
ISQL -E , restore database master from device='d:\dump\masterdump.dat'
restore fail with message
Error: 3151, Severity: 21, State: 0.
Error: 9001, Severity: 21, State: 1.
and sqlserver terminated..
I have try this.
1. backup a new masterdump from other sqlserver b and and restore to server
a .. same problem
2. take this masterdump from server b and restore to other server, sucessfu
l.
3. backup master from sqlserver(a) and restore to sqlserver(a) succesful.
i using sqlserver sp3
win2003 standard edition..
any suggestion?Hi,
Did you try rebuilding the master with rebuildm utlility and then try to
restore again?
Danijel Novak
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:3184264F-DC6F-4A12-B8B9-E7F8C508B14A@.microsoft.com...
> When i try to restore master db with
> sqlservr -c -m -T4022
> ISQL -E , restore database master from device='d:\dump\masterdump.dat'
> restore fail with message
> Error: 3151, Severity: 21, State: 0.
> Error: 9001, Severity: 21, State: 1.
> and sqlserver terminated..
> I have try this.
> 1. backup a new masterdump from other sqlserver b and and restore to
> server
> a .. same problem
> 2. take this masterdump from server b and restore to other server,
> sucessful.
> 3. backup master from sqlserver(a) and restore to sqlserver(a) succesful.
> i using sqlserver sp3
> win2003 standard edition..
> any suggestion?
>

restore master problem

When i try to restore master db with
sqlservr -c -m -T4022
ISQL -E , restore database master from device='d:\dump\masterdump.dat'
restore fail with message
Error: 3151, Severity: 21, State: 0.
Error: 9001, Severity: 21, State: 1.
and sqlserver terminated..
I have try this.
1. backup a new masterdump from other sqlserver b and and restore to server
a .. same problem
2. take this masterdump from server b and restore to other server, sucessful.
3. backup master from sqlserver(a) and restore to sqlserver(a) succesful.
i using sqlserver sp3
win2003 standard edition..
any suggestion?
Hi,
Did you try rebuilding the master with rebuildm utlility and then try to
restore again?
Danijel Novak
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:3184264F-DC6F-4A12-B8B9-E7F8C508B14A@.microsoft.com...
> When i try to restore master db with
> sqlservr -c -m -T4022
> ISQL -E , restore database master from device='d:\dump\masterdump.dat'
> restore fail with message
> Error: 3151, Severity: 21, State: 0.
> Error: 9001, Severity: 21, State: 1.
> and sqlserver terminated..
> I have try this.
> 1. backup a new masterdump from other sqlserver b and and restore to
> server
> a .. same problem
> 2. take this masterdump from server b and restore to other server,
> sucessful.
> 3. backup master from sqlserver(a) and restore to sqlserver(a) succesful.
> i using sqlserver sp3
> win2003 standard edition..
> any suggestion?
>