September 7, 2011 at 3:57 am
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
September 7, 2011 at 3:59 am
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.
September 7, 2011 at 4:03 am
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.
September 7, 2011 at 4:11 am
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
September 7, 2011 at 4:18 am
have you checked the server can be reached from the other server?
are the mirroring end-points enabled?
September 7, 2011 at 4:33 am
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.
September 7, 2011 at 5:10 am
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" 😉
September 7, 2011 at 5:15 am
servers are in the Workgroup.
September 7, 2011 at 5:25 am
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" 😉
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply