What is the size of database files (.MDF, .NDF) and transaction log files (.LDF)?

Do you take transaction log backups regularly?

1. Checkpoint writes dirty pages to disk. Not individual rows.

a. Did not understand the question. Eighter rollback or commit can happen. Not both.

2. When the server starts up next time,...

Just now I wrote this script. Please test it on test machine before running on production:

SET NOCOUNT ON

GO

EXEC sp_MSforeachdb 'USE [?]

select ''CREATE ROLE ['' + a.name + ''] AUTHORIZATION [''...

I have not come across script to transfer roles.

Others might pitch in

Right click on database ->Tasks -> Generate Scripts....

and select Database roles...

Please run this:

DBCC OPENTRAN()

SELECT name, log_reuse_wait_desc FROM sys.databases WHERE name = 'dbname'

You are running the wrong script (belongs to SQL 2000).

Get the right version for SQL 2005 from here http://support.microsoft.com/kb/918992

na1774 (8/8/2012)

---

So I changed the recovery model to Full. Took a Full Backup and then took a Transaction log backup hoping that Log file would be truncated. But The log...

B

🙂

Thanks Lavanya for sharing the solution.

Thanks Antony for leading to this solution.

No. All databases have PFS, GAM, or SGAM pages.

No. Latch type...

No need to recreate the whole subscription.

You can also avoid reinitializing the subscription.

You need to identify the row in the subscriber and fix it.

anthony.green (8/6/2012)

---

You have all the information you need in DBCC OPENTRAN, it gives you the SPID, so all you need to do now is query the DMV's to find out...

Any weekend maintenance job like index rebuild?

Are you using UI or sp_attach_db?

Please post the query you are using.