Storing MDF and LDF databases in a backup is a part of routine SQL Server maintenance task. Database backups help the user in recovering severely damaged SQL Server databases. MDF or Master database file is crucial for MS SQL Server because if MDF databases get damaged, all valuable user information on the server will be lost. You can create backup of MDF databases using SQLCMD utility. Read more about How SQLCMD queries help user in recovery of corrupt SQL databases? »

SQL Server consists of two essential elements where “data files” is one and other is “transaction log files.” Transaction log file keeps a log of incomplete transactions of databases. Therefore, when SQL Server service shuts down unexpectedly and when user restarts the server again, the read more...

SQL database corruption can make anyone worried, as it stores essential data. Identifying database table corruption can help to resolve the problem in a better manner. This post will discuss the basic symptom of SQL database corruption. You may encounter the following error in SQL Server read more...

When a user works with MS SQL Server 2005 and creates a report, he may face technical problems. Windows server may restart due to power failure and the user gets a screen prompting for the reason and information for restart of Server. Due to this OS issue, the SQL database becomes read more...

When you try to restore the Microsoft SQL Server database .MDF file from the sequence of transaction log backups, MS SQL Server database gets damaged. In such situations, you might have encountered the following event in the Application Event log of Microsoft SQL Server: “Filestream read more...

DBCC checks the logical and physical consistency of the SQL database and is able to resolve a few detected error messages. However, at times some issues cannot be resolved using the DBCC commands. SQL database corruption majorly occurs due to corrupt metadata, corruptions in certain read more...

In MS SQL Server 2000, the replication process usually runs without any issue for more than 377 days. But once these 377 days get over problem arises while accessing the Server. So when the user tries to run the SQL Server 2000 Transaction Replication, he gets an error message: “The read more...

Data files and Transaction log files are the two basic elements in Microsoft SQL Server. All the committed or uncommitted transactions are recorded by or handled by transaction log files. So whenever there is unexpected shutdown of SQL Server, this particular uncommitted log is added to read more...

In SQL Server, a database called tempdb is allocated for worktable / #temp table usage. Sometimes when the tempdb exceeds its maximum size limit, it starts behaving in weird manner. Possibilities of database corruption are very high when size of tempdb is larger than it should be, as when read more...

In SQL Server, a database called tempdb is allocated for worktable / #temp table usage. Sometimes when the tempdb exceeds its maximum size limit, it starts behaving in weird manner. Possibilities of database corruption are very high when size of tempdb is larger than it should be, as when size read more...

Search
Related Links