Search my blog
-
-
Recent Posts
- Reading list for the week – 24/10/11
- Reading list for the week – 17/10/11
- Reading list for the week – 10/10/11
- Reading list for the week – 03/10/11
- Reading list for the week – 26/09/11
- MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service exclusion path
- Reading list for the week – 19/09/11
Page Views
208,411-
Popular Posts
- How the Cannot generate SSPI context error was fixed
- Find the SQL Server Instance name using Task Manager
- Server is in script upgrade mode. Only administrator can connect at this time
- Script to check database user permissions
- Cannot create an instance of OLE DB provider ‘OraOLEDB.Oracle’ for linked server
Archives
Tags
backup configure data corruption data file hardware hotfix index internals locks maintenance plan performance PradeepAdiga restore RLFTW scripts security services setup sql 2000 sql 2005 sql 2008 sql 2012 sql agent ssis system databases tips and tricks tools Top Posts trace transaction log troubleshoot windows
Tag Archives: sql 2005
When was SQL Server restarted?
Over the weekend, I interacted with some of the “wanna be” DBAs. During the interaction I checked with them how they would find when was the SQL Server instance restarted? Everyone had a different approach to find out the information. Here are … Continue reading
Posted in scripts, SQLServerPedia Syndication
Tagged scripts, services, sql 2000, sql 2005, sql 2008, tools
7 Comments
SQL Server Service won’t start because I forgot to move the Resoruce database
On Sunday I got a call from a DBA from another team who had an issue that the SQL Server service was not starting up. It was a SQL Server 2005 instance. The SQL Server Error Log had the following … Continue reading
Posted in services, SQLServerPedia Syndication, Troubleshoot
Tagged services, sql 2005, system databases, windows
4 Comments
RSS
Email
Twitter
Ovi App
LinkedIn
FourSquare