October 7, 2009 at 1:29 am
tallapaneni_rao (10/7/2009)
i added ;-T1400 but still i am getting same error
Traceflag 1400 is only needed if you're running SQL 2005 RTM. If you're running SP1 or above, it's not needed, remove it. If you're running SQL 2005 RTM, apply some patches.
It would kinda help just a bit if you could tell us what the error message is, rather than just saying you are getting an error.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2009 at 4:05 am
i got the the error database transporter is disabled
error 1486 plz help
October 7, 2009 at 5:07 am
hi i am using sql server rtm what patches i need to apply
October 7, 2009 at 9:47 am
tallapaneni_rao (10/7/2009)
hi i am using sql server rtm what patches i need to apply
Apply SP3
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2009 at 5:02 am
hi i am doing mirroring i configured security wizard successfully but
when i am click start mirroring it showing
one or more of the server network addresses lacks a fully qualified domain name(fqdn).
specify the fqdn for each server, and click start mirroring again.
the syntax for fully qualified tcp address is:
tcp://<computer_name>,<domain_segment>[,<domain_segment>]:<port>
this error i am getting but my pc is non domain account
anyone plz help me
November 16, 2009 at 3:28 am
I performed the below steps:
(1) Taken the backups of the DB(Mirror) in the Principal Server and Created the same name DB in the Mirror server and tried to restore the DB with "NoRecovery" option.
But while tried to restore the DB in 'no recovery' mode getting the below error.
restore database [mirror]from disk
= 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Mirror_diff.bkp'
with file =2, norecovery, nounload, replace,stats =10
Error Msg::
Msg 4038, Level 16, State 1, Line 1
Cannot find file ID 2 on device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Mirror_diff.bkp'.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I executed the below command and found that file no =2 is there.
select file_number,physical_drive,physical_name from msdb..backupfile
Not sure why the error is coming?
Do I need to restore the DB (Mirror) in the Mirror Server with Recovery mode?
Screen shots of the Steps have been attached in the doc. Please check and assit on this.
Regards
Sourav
Thanks.
November 18, 2009 at 2:25 am
Can anyone please respond to my queries?
Thanks.
November 18, 2009 at 4:26 am
Hi,
No,don't restore mirror database with recovery .
it seems that mirror_diff.bkp file having some problem.
Hope so this not a production box...Repeat step of taking latest full backup from principle server & restore with overwrte & norecovery .
Start mirroring wizard...
Rd,
Deepali
August 22, 2012 at 11:55 pm
The same error I am getting.
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Neither the partner nor the witness server instance for database "adventureworks" is available. Reissue the command when at least one of the instances becomes available. (Microsoft SQL Server, Error: 1431)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=1431&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Any solutions ???
Viewing 9 posts - 31 through 38 (of 38 total)
You must be logged in to reply to this topic. Login to reply