Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

TempDB Deleted Accidentally Expand / Collapse
Author
Message
Posted Wednesday, May 4, 2011 10:11 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 2:34 PM
Points: 541, Visits: 789
Well done, thank you! I don't care how many times single user mode has been written about. We all can use another reminder, because this is not something people use on a daily basis.


Post #1103268
Posted Wednesday, May 4, 2011 12:34 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, November 2, 2014 1:00 PM
Points: 368, Visits: 544
In-addition to above, i think this needs a correction:

Article says: I stopped the SQL Server Agent from the configuration manager.

Actually, the status of SQL Server Agent should be stopped anyways (remember there is a dependency on SQLServer)
In-fact you should make it disable or manual to save that single connection of SQL Server.

Thanks,
Sarabpreet Singh


Regards,
Sarabpreet Singh
SQLServerGeeks.com/blogs/sarab
www.Sarabpreet.com
Twitter: @Sarab_SQLGeek
Post #1103412
Posted Wednesday, May 4, 2011 12:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, November 15, 2014 1:01 AM
Points: 1, Visits: 91
Nice article. I've been a DBA for about 15 years, and it's good to see stuff like this, even if it has already been written about many times. Well done.

I also managed a DBA group for about 5 years, and yes, little questions like this do come up in the interviews.
Post #1103425
Posted Wednesday, May 4, 2011 8:21 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 10, 2014 9:20 PM
Points: 117, Visits: 465
@Lance Reger.. The thing is that the tempdb is created every time the SQL Server restarts taking the database template from tempdb. But if the location is not present then the tempdb cannot be re-created. Matter of fact that the tempdb is deleted everytime SQL Server is shutdown. So accidently deleting it means there is no re-covery back directly. Hope I answered the question put forward.

Tushar
Post #1103593
Posted Saturday, March 10, 2012 8:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 7:21 PM
Points: 268, Visits: 897
You may like to see some TF like 3609 / 8 / 7 these come handy.
Post #1264733
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse