restore taking too long - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

restore taking too long

Author

Topic

Rushabh
Starting Member

11 Posts

Posted - 2008-10-09 : 09:01:41

Hi all,
I have restored a 6 GB database from SAN storage to SQL Server 2005 using Netbackup 6.5.
In the logs in Netbackup we can see the database is resotred successfully.
But I am not able to open the database from SQL Server Management Studio. it shows (Restoring...).

Can anyone help me here..

Regards,
Rushabh

DBA

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-09 : 09:03:07

Looks like you restored with NORECOVERY option. Can you post your full restore command?

Rushabh
Starting Member

11 Posts

Posted - 2008-10-09 : 09:14:07

hi,

thanks for reading..

here is the script that I have used..

OPERATION RESTORE
OBJECTTYPE DATABASE
DATABASE "sob2ksq_backup_db121"
MOVE "lanung"
TO "E:\Program Files\Microsoft SQL Server\90\MSSQL.1\MSSQL\Data\sob2ksql121_backup_db.mdf"
MOVE "lanung_log"
TO "E:\Program Files\Microsoft SQL Server\90\MSSQL.1\MSSQL\Data\sob2ksql121_backup_db_log.ldf"
# The following image is type: Full
NBIMAGE "sob2ksql121.MSSQL7.SOB2KSQL5.db.lanung.~.7.001of001.20081001220708..C"
SQLHOST "rushabh"
NBSERVER "SOBSANBM"
BROWSECLIENT "sob2ksql121"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE NOTRECOVERED
NUMBUFS 2
ENDOPER TRUE

Regards,
Rushabh

DBA

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-09 : 09:22:45

quote:
Originally posted by Rushabh

hi,

thanks for reading..

here is the script that I have used..

OPERATION RESTORE
OBJECTTYPE DATABASE
DATABASE "sob2ksq_backup_db121"
MOVE "lanung"
TO "E:\Program Files\Microsoft SQL Server\90\MSSQL.1\MSSQL\Data\sob2ksql121_backup_db.mdf"
MOVE "lanung_log"
TO "E:\Program Files\Microsoft SQL Server\90\MSSQL.1\MSSQL\Data\sob2ksql121_backup_db_log.ldf"
# The following image is type: Full
NBIMAGE "sob2ksql121.MSSQL7.SOB2KSQL5.db.lanung.~.7.001of001.20081001220708..C"
SQLHOST "rushabh"
NBSERVER "SOBSANBM"
BROWSECLIENT "sob2ksql121"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE NOTRECOVEREDNUMBUFS 2
ENDOPER TRUE

Regards,
Rushabh

DBA

You should run in RECOVERY STATE.

Rushabh
Starting Member

11 Posts

Posted - 2008-10-09 : 10:31:08

hi,

thanks I was able to do that after installing SP2..

Regards,
Rushabh

DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources