How to Recover or Repair Suspect Database in SQL Server
Suspect database in SQL Server is not very common issue but there are times we face it because of various…
14 years ago
Manvendra Deo Singh
Error 14258: Cannot perform this operation while SQL Server Agent is starting. Try again later
I saw SQL Server error 14258 today while i was diagnosing my log shipping issue in which primary and standby…
14 years ago
How to Disable AutoCommit in SQL Server?
Autocommit mode is the default transaction management mode of the SQL Server Database Engine. Every Transact-SQL statement is committed or…
14 years ago
Fix: Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing a query for execution against OLE DB provider ‘ADsDSOObject’. OLE DB error trace [OLE/DB Provider ‘ADsDSOObject’ ICommandPrepare::Prepare returned 0x80040e14].
Whenever you get the issue "Msg 7321" make sure your security context is correctly supplied. Otherwise you will get below…
14 years ago
How to get Last Restore Time of your database?
Database Backup and restores are common task for any database administrator. We generally do lot of restore operations to fulfill…
14 years ago
How to find Total no of Traces Running on your Database Instance?
Suppose you want to find out how many traces are running on your SQL Server database instance? If you don't…
14 years ago
Error Msg 1813, Level 16, State 2, Line 1, Could not open new database ‘yourdatabasename’. CREATE DATABASE is aborted.
The error 1813 comes when corrupt transaction log are attempted to attach to new server. Error details are given below:…
14 years ago
How to Move Table to Another Filegroup?
Suppose we had a database that has grown very large in size and located on the D drive that had…
15 years ago
Understanding Point in Time Recovery in SQL Server
Point In Time recovery is a process to recover or restore your database till the point it was lost. Sometimes…
15 years ago
Not able to open DTS package in sql server 2008 or sql server 2005.
When you get below DTS package error during accessing it then you should apply solution given in below section to…
15 years ago
How to Kill all sql server process
Sometimes we need to kill all sql server transactions to perform any task.If you have to do this pls follow…
15 years ago
Error 14151:Replication Agent failed to start.
I got below error 14151 for one of my SQL Server Replication Agent. The SQL Server Replication Agent may not start…
15 years ago
Move all DTS Packages between servers.
We can move all DTS packages from one server to another server through given two methods:Method1:If you save your dts…
15 years ago
Database is in transition
This issue comes when you tried to make your database offline and during this process you run the cmd sp_who2.There…
15 years ago