This blog has been written with the motive of giving readers a quick overview about the difference between Tables and Views in SQL Server. W...
Read More
Violation of Primary Key Constraint Error Code 2627
Suppose, you want to insert some data in SQL Server database using an INSERT SELECT statement that contains a primary key, and when you run ...
Read More
Fix - Restore Database is Terminating Abnormally Error 3013
SQL Server Error 3013 Let’s understand the SQL Server error 3013: Restore Database is Terminating Abnormally. Suppose, you changed the lo...
Read More
How to Restore a Single Table in SQL Server from Backup
Restore a Single Table in SQL Server Suppose, you have a table in your SQL Server database that has several important data items, but your ...
Read More
SQL Server Truncate and Shrink Transaction Log File
First, we should know what is transaction log file in SQL Server and what is the difference between truncating and shrinking of log file? L...
Read More
Restore Files and Filegroups in SQL Server from Backup
In the previous article we have discussed about SQL Server database files and filegroups and how to backup the file and filegroups. In this...
Read More
SQL Server Database File and Filegroups and Backup
What is SQL Server database filegroups Every database has a primary file group. SQL Server Database filegorup contain both primary as well ...
Read More
Subscribe to:
Posts (Atom)