Viewing 15 posts - 15,946 through 15,960 (of 22,219 total)
Shut down the server, muck with the file using an editor as Steve said, restart the server. Tada. Totally hosed database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 30, 2009 at 8:42 am
Just adding a note to your original question and the excellent answer already provided.
Not only can you restore up the chain in terms of versions, but you can restore...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 30, 2009 at 7:25 am
Excellent, excellent, excellent post. Nothing is more important than verifying backups, except, verifying that you know how to run a restore. You're absolutely right when you say that backups are...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 30, 2009 at 5:28 am
Lynn Pettis (12/29/2009)
Kassondra was in a car accident Sunday...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2009 at 1:17 pm
GSquared (12/29/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2009 at 11:00 am
I agree, I'd start with Maintenance plans since you're just starting out.
The mechanism for scheduling operations within SQL Server is a service called SQL Server Agent. By default it's installed...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2009 at 6:42 am
You don't mean sp_configure do you? All the SQL Server settings, memory allocation, all that stuff? Or are you really looking even lower level at the server instance itself? If...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2009 at 6:11 am
klnsuddu (12/28/2009)
If the Index rebuild maintenance plan run on weekly basis, then NO need to run Update statistics maintenance job?thanks
You will still need to update statistics. I'm pretty sure the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2009 at 5:19 am
jcrawf02 (12/28/2009)
Grant Fritchey (12/28/2009)
I've also been playing a lot of Call of Duty Modern Warfare 2.
I've been instructed that we will have a Christmas: Take 2 for New Years, and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 28, 2009 at 11:47 am
Steve Jones - Editor (12/28/2009)
you're welcome to come out here. We have land, Scouts, and snow 🙂
Keep the snow. The rest sounds great. Now, are there jobs?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 28, 2009 at 11:46 am
river1 (12/28/2009)
But , with this apps can people be notified by this two ways? e-mail and mobile phone message?
Both of the ones I mentioned work with either. After all, it's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 28, 2009 at 11:45 am
Steve Jones - Editor (12/28/2009)
Grant Fritchey (12/28/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 28, 2009 at 9:18 am
GilaMonster (12/28/2009)
Grant Fritchey (12/28/2009)
I'm not even remotely a Star Wars fanboyAaahhh... Heresy!
😀
Yep, speak it fluently.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 28, 2009 at 9:16 am
GilaMonster (12/28/2009)
Am currently...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 28, 2009 at 8:54 am
Yep, no need for a dba.
Need fewer developers too since you can use objects already developed in the cloud.
It's the end of IT!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 28, 2009 at 8:47 am
Viewing 15 posts - 15,946 through 15,960 (of 22,219 total)