SQL server could not start cannot find object or property (0x80092004) Recently I got a call from my team the users couldn’t connect the SQL server and it’s throwing error. As always, I checked the SQL server status via configuration manager and noticed the server 2008 r2 stopped. I tried to start the SQL server but it’s not started and its shows could not start the service. I went to the application log it has so many error messages. Event viewer Errors: Could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems. Could not start the network…
-
-
AWE has removed from SQL server 2012
AWE has removed from SQL server 2012 AWE has removed from SQL server Denali onwards. Say bye bye to 32 bit servers. To use more than 4GB memory you have to buy 64 bit servers. A small organization may suffer because of this feature has removed from the next version. For more look the following links SQLOS Team’s post : SQL Server Memory Manager Changes in Denali http://sqlblog.com/blogs/sqlos_team/archive/2011/01/04/sql-server-memory-manager-changes-in-denali.aspx MS’s post : Features Not Supported in the Next Version of SQL Server http://msdn.microsoft.com/en-us/library/ms143729.aspx
-
SQL server 2012 Denali not starting there is insufficient memory available in the buffer pool
SQL server 2012 does not start Today is not a good day. Ha ha not like that 🙂 Usual I opened SQL server DENALI to play something it doesn’t open (start) it at all. It’s throwing error. Probably you know what I will do I went configuration manager checked the service is started or not. It shows stopped. I tried to start the server but, it’s not start it. I checked the event viewer log and the SQL error log I got lots of error. Event viewer logs: The SQL Server (SQL2011) service terminated with service-specific error %%945. There is insufficient memory available in the buffer pool. SQL server error…
-
SQL server Database backup restores sequence Steps
SQL server Database restores sequence Steps I have seen many people are still unclear about the database restoration sequence. Recently I have answered a number of database restoration questions SSC, MSDN… I got a comment from Anonymous user. It’s a simple task to the experienced DBAs. However it’s very important to know the database restoration sequence. It’ll help number of situations. For example, Your database got damaged in any one of the reasons. (Or) You may get a request from the DEV team to restore a database from production to development. I have already written an article about Step by step backup/restore using T-SQL. But it’s not fully focus the restoration sequence. Here I…
-
Restoring a database from higher version to lower version SQL server
Restoring a database from higher version to lower version SQL server How to downgrade a database from higher version to lower version? There is no direct way to do this like Backup/Restore. You can use an alternative ways. The alternative ways are, 1. Generate Script 2. Import/Export 3. Transaction replication You may use the alternative ways. It depends upon your environment. Restore errors A backup has taken from higher version (SQL 2008/2005) BACKUP DATABASE dba_test TO DISK='E:\mu\dba_2008.bak' Restore the backup to lower version (SQL 2005/2000) RESTORE FILELISTONLY FROM DISK ='E:\mu\dba_2008.bak' Restore error from SQL server 2005 to SQL server 2000 Server: Msg 3205, Level 16, State 2, Line 1 Too many backup…