Author: Deepak
-
Log file growth in SQL Server
Each database in SQL Server contains at least one data file and one transaction log file. The transaction log file stores the details of all the modifications that are performed in the SQL Server database. If the transaction log file in a SQL Server database has grown enormously and if you have set the option…
-
How to Recover from Suspect Database
Many DBAs would have seen the database marked as suspect. If a database is marked suspect it cannot be accessed and hence nothing can be performed in the database. In this article I am going to explain how to overcome this and bring the database back to normalcy. There are three possible Workarounds to bring…
-
SQL Server 2005 Default trace
The Default Trace is implemented to audit certain events in the system. To verify if the default trace is running, run following query:
-
Schema changes in SQL Server 2005 Transactional Replication
Schema changes will be replicated by default. I am adding a column named street to the table Address using the below command,
-
Mirrored Backups
Mirrored backup is a feature available in SQL Server 2005 Enterprise Edition and Development Edition. Mirroring a media set increases backup reliability by adding redundancy of backup media which effectively reduces the impact of backup-device failing. While taking backup of database, same backup is taken on multiple media or locations.