Viewing 15 posts - 211 through 225 (of 1,270 total)
AlwaysOn Failover Clustering Instance (FCI) (which is not the same thing as AlwaysOn Availability Groups) does require the same database start up as earlier versions of failover clustering. So, yes,...
July 21, 2012 at 11:56 pm
opc.three (7/20/2012)
not sure how you calculated it using fn_dblog
Page splits have a Transaction Name of 'pagesplit'. It's just a matter of counting them and dividing by the number of seconds...
July 21, 2012 at 11:35 pm
pooyan_pdm (7/21/2012)
July 21, 2012 at 11:20 pm
Vikrant is correct. Just make sure you use a file path that exists on the mirror. the whole path to the file has to exist (but not the file itself)...
July 21, 2012 at 11:14 pm
Are you administering the SAN yourself? If not, this is something the SAN admin needs to configure on the SAN side before you cna do anything with it on the...
July 21, 2012 at 11:12 pm
The second error was caused by the first error, so you can ignore the second one for troubleshooting purposes. the first error clearly indicates a worker thread consumption problem. All...
July 21, 2012 at 11:10 pm
Your plan is mostly good. delete the part about copying logins (that part is bad .... real bad).
If you want some more details on this failover process, I wrote an...
July 21, 2012 at 11:04 pm
Updating the tables manually isn't supported (though if done completely and correctly, it should work).
The supported way is to drop log shipping and reconfigure it. Because the databases are in...
July 21, 2012 at 10:57 pm
Marios Philippopoulos (7/21/2012)
Could the slow restore rate be caused by high file fragmentation on the mirror server?Perhaps we are due for a file defrag outage.
No file level fragmentation would cause...
July 21, 2012 at 10:55 pm
cmoy, when you're shrinking the file, it won't resize the file until it's done moving chunks around. So you're not going to see it shrinking a little at a time....
July 19, 2012 at 2:32 pm
SQL ORACLE (7/19/2012)
Make a full backup for this database and then shrink the database.
What difference will that make?
July 19, 2012 at 2:30 pm
From Books Online: Embedding SQL Server 2008 Express in an Application
July 19, 2012 at 12:07 am
It is okay to shrink a file for a one-off situation like this. Not something you should do regularly. And you should plan for rebuilding the indexes afterwards because fragmentation...
July 18, 2012 at 2:16 pm
Other suggestions would be to pull the data locally rather than using linked servers.
July 18, 2012 at 9:34 am
1. Shrinking the data file does not use a lot of log space.
2. Never use ShrinkDatabase. If you must shrink a file, use ShrinkFile. ShrinkDatabase basically calls ShrinkFile for every...
July 18, 2012 at 9:33 am
Viewing 15 posts - 211 through 225 (of 1,270 total)