My doubt is about retention period, http://msdn.microsoft.com/en-us/library/ms152497.aspx can you please check and confirmed if retention period is...
Apart from what Shehap and Luis has added, my point was - Auto Growth may trigger high I/O while expanding file size. For example, if you have a...
Hi Paul, Is it taking this long everytime or just one time ? How are you growing TLog file? Manually ? what is the auto growth option set to % or...
Hi WingSZeto, To my understanding, when you performed restored you've missed to say "preserve replication settings", refer...
Hi KSR, As Luis mentioned, did you observed any maintenance activity while backup job was running ? I would suggest check job history and SQL Logs...
Do you mean you need to get your secondary database online ? If so, you can use RESTORE DATABASE WITH RECOVERY for the purpose. Sorry, but I still...
Hi, I would suggest you to refer and follow manual uninstall steps http://support.microsoft.com/kb/955404, and, before doing that can you please...
In your case, afaik Yes. When you have a full backup which is completed at 12:53 it will have all the data which includes you TLog backup.
In Cluster environment, the SQL Server cluster would be a virtual; thus it would not be on any physical node per say. For example, There is a SQL...
Did you just created or altered SP ? If so, it is more likely because of the fact that the first time the SP runs will not have execution plan...
in my recent assignment we saw the kind of issue and the culprint was the lan cable of the heartbeat network, and in another case its SAN drive...
Did you checked if there is an indication of an issue with a hearbeat network / resource which is triggering this ? Is there a pattern that you are...
+1, its supported and working fine.
So true my friends, completely agree with this :) I heard another one too..... There are 3 words that can give heart attack to man if he heard them...
were you able to access the publisher from the subscriber ? If so, did you try creating subscriber by invoking wizard from subscriber (named instance...
Here are the two links that can be a help to you in this case : http://www.sqlservercentral.com/articles/Transparent+Data+Encryption/66334/...
Is there any error message you are getting? At what step / level you are getting the error message ?
are you sure you have configured the db mail properly ? I guess the smtp server you are using accepts SSL connection / required you to provide...
Here are few more for your reference : http://technet.microsoft.com/en-us/library/cc731188%28WS.10%29.aspx...
There are two option IMO, a) Configure snapshot replication - > provided, this one is to be used as read only / reporting purpose b) Transaction...
Separate names with a comma.
