Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database in Restoring State Expand / Collapse
Author
Message
Posted Wednesday, September 7, 2011 3:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 7, 2011 6:32 AM
Points: 4, Visits: 14
I need to Restore the Database with NoRecovery, when i did like this, Database is showing in Restore State, can't do anything for the Database. I am doing the Database Mirroring, for this i need to Restore the DB with NoRecovery.

Following is the sql i used to restore the database, Please check this sql and tell me any mistake in this sql.

RESTORE DATABASE Test FROM DISK = N'D:\DB\Test.bak' WITH FILE = 1, MOVE N'Test' TO N'D:\SQL_Files\Test.mdf', MOVE N'Test_log' TO N'D:\SQL_Files\Test_log.ldf', NORECOVERY,REPLACE, NOUNLOAD, STATS = 10
GO
Post #1170938
Posted Wednesday, September 7, 2011 3:59 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
when you restore with no recovery then the database will be in a 'restoring' state, until you bring in online. so what you are seeing is correct.

This is required for the mirrored database, and the mirrored database will not be able to be used only the principal database will be used in mirroring.
Post #1170941
Posted Wednesday, September 7, 2011 4:03 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 4:17 AM
Points: 1,101, Visits: 5,279
robymon78 (9/7/2011)
I need to Restore the Database with NoRecovery, when i did like this, Database is showing in Restore State, can't do anything for the Database. I am doing the Database Mirroring, for this i need to Restore the DB with NoRecovery.

Following is the sql i used to restore the database, Please check this sql and tell me any mistake in this sql.

RESTORE DATABASE Test FROM DISK = N'D:\DB\Test.bak' WITH FILE = 1, MOVE N'Test' TO N'D:\SQL_Files\Test.mdf', MOVE N'Test_log' TO N'D:\SQL_Files\Test_log.ldf', NORECOVERY,REPLACE, NOUNLOAD, STATS = 10
GO

There is NO mistake in your sql. Restore state is the correct state. Go ahead and configure Database Mirroring.
Post #1170945
Posted Wednesday, September 7, 2011 4:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 7, 2011 6:32 AM
Points: 4, Visits: 14
I am getting the following Error Messages when i click Start Mirroring. what could be the problem.

An error occurred while starting mirroring.

------------------------------
ADDITIONAL INFORMATION:

Alter failed for Database 'Test'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server network address "TCP://ECDOSD-MISimage:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
Post #1170950
Posted Wednesday, September 7, 2011 4:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
have you checked the server can be reached from the other server?

are the mirroring end-points enabled?
Post #1170953
Posted Wednesday, September 7, 2011 4:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 7, 2011 6:32 AM
Points: 4, Visits: 14
I can connect other server through sql authentication. How can i check the TCP connection. when i configure the Mirroring it is not putting the IP address, showing TCP://ECDOSD-MISimage:5023. how can i check this? Mirror end point is started.
Post #1170958
Posted Wednesday, September 7, 2011 5:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 6,162, Visits: 13,305
are the servers used in the mirroring part of a windows domain or are they in a workgroup?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1170965
Posted Wednesday, September 7, 2011 5:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 7, 2011 6:32 AM
Points: 4, Visits: 14
servers are in the Workgroup.
Post #1170969
Posted Wednesday, September 7, 2011 5:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 6,162, Visits: 13,305
to configure database mirroring for servers in a workgroup you will need to follow this link as the GUI tries to use Windows authentication only

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1170973
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse