Introduction In the previous article we have discussed how to create SQL Server database backup using SQL Server Management Studio and Transact-SQL. Now in this article we Learn More →
Nowadays many users got confused on how Backup types are related to Recovery Model.Here I will let you know, what role does backup type play in SQL Learn More →
A Transaction Log is a file that contains all the records of transactions and the database modifications made by each transaction in SQL Server database.The log file Learn More →
Overview Transaction log files contains records of all database transactions to help users in ensuring data integrity at the time of system restore. However, there are many Learn More →
If you are an SQL Server user, you may come across any error while performing your everyday task. Errors can occur due to different reasons and separate Learn More →
SQL users often face the issue of slow SQL Server database, which is caused by I/O related bottlenecks in SQL Server. I/O subsystem is a major element Learn More →
Microsoft SQL Server login failed error 18456 can be encountered due to varied reasons. When this error occurs, the server name entered is correct, but because of Learn More →
A server administrator’s job is to keep tab on all the activities and status of the platform. Monitoring SQL Server disk space on the server is amongst Learn More →
In SQL server, while restoring database from a backup file user come across a very common error i.e. SQL Server error 14421 Error: 14421, Severity: 16, State: Learn More →
One of the most essential need of every Database Administrator is a backup file. This file acts as a life savior when any disaster occurs either on Learn More →
