Viewing 15 posts - 61 through 75 (of 131 total)
michael.french 172 (6/30/2011)
To do so, from the Services Window, stop the sql server and then...
June 30, 2011 at 9:18 am
shaun.stuart (6/9/2011)
- get rid of the switch from full or bulk to simple mode or make this an option. This could break log shipping, backup chains,...
June 9, 2011 at 2:18 pm
Some changes I would make:
- get rid of the switch from full or bulk to simple mode or make this an option. This could break log shipping, backup chains, etc....
June 9, 2011 at 2:12 pm
Figured it out and it was due to a combination of two problems.
We have a SAN backup that, for some reason, is causing mirroring to fail over to the mirror...
March 23, 2011 at 10:38 am
Thanks. I'll try that. But I did check msdb backupset and one of those other msdb backup tables and it didn't show any other full backups being made. I'm assuming...
March 23, 2011 at 9:28 am
Gail - Yup - the backups are all done natively. Nothing else is backing up the databases. We don't use any third party tools.
Ashish - Yes, I tried restoring the...
March 23, 2011 at 8:54 am
sqlquery-101401 (2/6/2011)
can some body please point me the list of db mirroring event ids like 1479 for time out , i need to monitor db mirroring suspend ,disconnect state etc...
Not...
February 7, 2011 at 10:22 am
Doh! The very last line... I completely overlooked it.. Thanks!
Shaun
February 4, 2011 at 1:10 pm
GilaMonster (2/3/2011)
The ndf is definitely from a different database as the mdf.It also looks like the database was SQL 2005 or 2000, not a 2008 database.
Hi Gail.. I'm just following...
February 4, 2011 at 1:00 pm
Kimberly Tripp has some code on her blog on how to do this. Her routine will rebuild clustered and non-clustered indexes based on the fragmentation level.
February 3, 2011 at 8:01 am
sqlnaive (1/31/2011)
Dear Friends, Do you have checklist for pre migration from SQL Server 2005 to SQL Server 2008 ?
I recommend using Microsoft's SQL 2008 Upgrade Advisor, available here.
I agree...
February 2, 2011 at 11:04 am
subbu_e (2/1/2011)
What is purpose of this kind of approach if the server goes down none of the database will be available.
If which server goes down? If anyone one goes down,...
February 1, 2011 at 2:39 pm
Hmm..i think this could be done, but it wouldn't be pretty. You can configure alerts for error level 17 through 25. As the Response for those, have them execute a...
January 28, 2011 at 8:25 am
Viewing 15 posts - 61 through 75 (of 131 total)