0
votes
1answer
237 views

SQL Server 2008R2 Transaction Replication Stop and Restart but continue log backups

In a database that is currently being replicated I want to stop the replication (stop the log reader process) for a period of time though I want to continue to take log backups on that same database. ...
0
votes
2answers
529 views

Advised auditing method for MS SQL to track changes made to a specific table by a specific user?

What is the best method for tracking changes or logging the queries done to a table by a specific user when the person is using Management Studio? I'm using 2008 R2 Express Edition and want to ...
1
vote
2answers
132 views

Transaction log backups

I'm studying for the 70-432 (SQL Server 2008) exam, and I'm a bit confused about how the transaction log works. From what I understand, (correct me if I'm wrong...) the log is actively stored in ...
0
votes
1answer
51 views

SQL Server 2008 R2 Transactions Files

Trying to restore a lost Server 2008 database. Had a backup from 2 weeks ago and were able to get the transaction log files. So I restored the DB in norecovery mode and started restoring the ...
3
votes
2answers
4k views

How to shrink 40GB LOG file

I have a problem that is my log file in SQL Server 2008 is grown to 40Gb and I wanted to shrink it. The query I am using is ALTER DATABASE DatabaseName SET RECOVERY SIMPLE use DatabaseName GO ...