Suspect database in SQL Server is not very common issue but there are times we face it because of various reasons. Such reasons can cause a database to go in suspect mode and become inaccessible for end users. There are...
I saw SQL Server error 14258 today while i was diagnosing my log shipping issue in which primary and standby servers was not in sync. I checked log but i didn’t find anything even SQL Server agent was running and...
Autocommit mode is the default transaction management mode of the SQL Server Database Engine. Every Transact-SQL statement is committed or rolled back when it completes. If a statement completes successfully, it is committed; if it encounters any error, it is...
Whenever you get the issue “Msg 7321” make sure your security context is correctly supplied. Otherwise you will get below error. Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing a query for execution against OLE...
Database Backup and restores are common task for any database administrator. We generally do lot of restore operations to fulfill user’s requirement. Such restores might be from production to lower life cycles or between the different landscapes like QA to...
Suppose you want to find out how many traces are running on your SQL Server database instance? If you don’t have any idea about it then you should read this article to get the answer. Here is a solution to...
The error 1813 comes when corrupt transaction log are attempted to attach to new server. Error details are given below: Msg 1813, Level 16, State 2, Line 1, Could not open new database ‘yourdatabasename’. CREATE DATABASE is aborted. If you...
Suppose we had a database that has grown very large in size and located on the D drive that had a 100 GB Capacity. Now drive D is running out of space. We had other drives on the server where...
Point In Time recovery is a process to recover or restore your database till the point it was lost. Sometimes detrimental command will probably be issued against one of your databases and you will need to recover the lost data....
When you get below DTS package error during accessing it then you should apply solution given in below section to fix this issue. SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download,...
Sometimes we need to kill all sql server transactions to perform any task.If you have to do this pls follow any one of the given steps. 1-Through management studio,when you will try to detach the db there is a option...
I got below error 14151 for one of my SQL Server Replication Agent. The SQL Server Replication Agent may not start and will throw error message: The replication agent is not registered properly. Rerun SQL Server setup. The step failed. [SQLSTATE...
We can move all DTS packages from one server to another server through given two methods:Method1: If you save your dts packages under local packages, they are stored in the msdb.dbo.sysdtspackages table.1) create a new dts package with connections to...
This issue comes when you tried to make your database offline and during this process you run the cmd sp_who2.There are some transactions in process and you try to make database offline, then you will have to sit with patience...
