Viewing 15 posts - 2,146 through 2,160 (of 2,463 total)
parthi-1705 (3/3/2010)
SQL Server cannot create the mirroring endpoint, 'Mirroring'.ADDITIONAL INFORMATION:
----------------------------------------------------------------------------------
Create failed for Endpoint 'Mirroring'. (Microsoft.SqlServer.Smo)
TRy few things ;
1) Try to telnet your port for mirroring point.
2) Have you restarted...
March 3, 2010 at 5:51 am
Can you post exact Error you got ?
March 3, 2010 at 4:26 am
gupta1282 (3/3/2010)
What is Difference between both and which is better
You need some homework buddy:-)
Read below post
http://www.sqlservercentral.com/Forums/Topic286477-92-1.aspx
http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/086923c4-92c5-4d85-9cea-578dd097b118
March 3, 2010 at 2:11 am
Few questions :
Are both the instances on same machine?
Are you trying to implement mirroring first time on them ?
Have you tried Wizard for mirroring ?
March 3, 2010 at 2:03 am
Bhuvnesh (3/3/2010)
mike mcneer (3/2/2010)
Maybe SQL is detecting some type of corruption and is kicking of the dbcc checkdb to verify consistency.
Can it be possible that Sql server automatically run DBCC...
March 3, 2010 at 12:39 am
mike mcneer (3/2/2010)
Maybe SQL is detecting some type of corruption and is kicking of the dbcc checkdb to verify consistency.
Can it be possible that Sql server automatically run DBCC Checkdb...
March 3, 2010 at 12:34 am
RBarryYoung (3/2/2010)[hrthis would all be a lot easier and simpler if you did this in a set-based way
I didnt get you here ? any example ?
March 2, 2010 at 10:12 pm
DECLARE MC CURSOR READ_ONLY FOR
SELECT [Str]FROM #Windows_Auth_Orphan_User
...
March 2, 2010 at 7:38 am
blue_inelush (3/2/2010)
In order to avoid this, my understanding is that I have to run manually from time to time a shrink operation.
Well if it works for you. you can...
March 2, 2010 at 6:08 am
then try to work with ALZDBA first post but with secure hands and watchful eyes. see if it can help you
March 2, 2010 at 5:51 am
blue_inelush (3/2/2010)
the .ldf file was constantly at a small size(at the log backups it was decreasing without making any shrink!!!!).
Do you have any maintenance plan or (job running periodically )...
March 2, 2010 at 5:00 am
can u tell me how much space recovered in weekends and how can u say that it didnt work today(didnt u find any shrinking in log not even in MB...
March 2, 2010 at 4:48 am
When you try to shrink a transaction log file that has little free space in SQL Server 2005, you may have to perform an additional log backup operation. The additional...
March 2, 2010 at 4:21 am
parthi-1705 (3/1/2010)
HiWhich is good Sub query or Joins ?
Thanks
Pathi
i did some testing like convert your table variable into temp table and placed clustered index on RID.
and see execution...
March 2, 2010 at 3:39 am
Viewing 15 posts - 2,146 through 2,160 (of 2,463 total)