Might be a stupid question.... but.. what is the error message?

The fix will not be applicable because of two reasons.

1. In SQL 2005 there is no single procedure fires in background (i captured Profiler trace)

2. you cannot update system objects...

error code 0x5. = Access is denied

BUT 0x534 means "No mapping between account names and security IDs was done"

does it give you some clue?

Can you check if you have same message in SQL Error Logs?

I feel there is something wrong with registry setting.

http://support.microsoft.com/?id=883732

Since your OS is able to see 7 GB of memory, it means you need not enable PAE. As far as i know, its enabled by default with Windows 2003.

Rest...

I tried same thing here but no luck to see same behaviour

Below were my steps

1. User DSN

2. SQL Server driver

3. Provided msdb as default database

4. tested connection and it worked.

5....

TITLE: Surface Area Configuration

------------------------------

To configure the surface area, one or more services for the Database Engine or Analysis Services or Reporting Services must be running. (SQLSAC)

------------------------------

BUTTONS:

OK

------------------------------

Is this the error message...

can you please provide exact error message?

Please try

DBCC DBRECOVER('pubs') -- Replace pubs with database name

http://msdn2.microsoft.com/en-us/library/ms189080.aspx 

Consider following information when you plan to shrink a database:

·         A shrink operation is most effective after an operation that creates lots of unused...

Agree with Lynn.

Can't you schedule log backup as a job?

Do you have some trigger defined on the table?

Can you run profiler trace i the backgroup and see the error?

Can you install the secondary server will exactly same disk structure as on primary? If yes, then its piece of cake...

1. Stop SQL on Secondary and Primary.

2. Move all...

I was not aware if my statement will be changes to Wink

DBCC INPUTBUFFER(51) -- SPID = 51

DBCC INPUTBUFFER(<SPID&gt