Message

The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'msdb.dbo.syspolicy_event_queue' output the following: 'Cannot execute as the database principal because the principal "##MS_PolicyEventProcessingLogin##" does not exist, this type of principal cannot...

vamshi.sql (6/22/2010)

---

I am not able to set the DB to Multi_User mode.I have the backup file with me,If I want to delete the DB also I am unable to do...

Try domain account to connect , the domain account should be added to the admin group of the monitoring server.

You are right Wayne, we had the same experience in our PROD env. There was a uindex rebuild job which was the culprit. Any way shrinking Tlog periodically will fragement...

When you setup log shipping always use domain account with never expired password.

The domain account should have full access to the tlog backup and tlog copy/restore folders with full...

You need to find out why the tlog grow so much is there any uncommited transactions ? or log running queries that increase the log size? What is the...

Nic-1052152 (6/9/2010)

---

Hi Minaz

is this because in simple mode it truncates the transaction log and in full it doesnt unless you ask it to by doing the transaction log backup? sorry...

Try restoring tlog manually and check the profiler why it takes such a long time. Another question do you have any anti virus install on the server 2 where you...

If the recovery model is full , taking a full backup over the log shipping setup will not impact the log shipping.

You can schedule your backup in such a...

What is the outpur of desc column in log_reuse_wait_desc. If any Replication is setup? If Script out the subscription, drop the subscriber, back up the log, shrink it

to something smaller...

What did SQL error log says? Check if Remore connection is enabled

Paste the full error.

Added a checklist which we followed during migration.

Migrtion Pre checklist

1OS & Service pack of both the Server

2RAM & CPU detail

3Analyse the disk space in the Target Server

4Physical layout...

We do not have SAN , I am going to use SSIS package to append the records. Any other pointers?

Thanks everyone for the replies 🙂

So I have two options:

1. Use SAN Clone to refresh the data between Prod and Stage

2. SSIS package to append the data.

Will update the group...

Would you post the summary and detail text.