PhilM99 (9/24/2009)

---

Thanks to Silverfox and ALZDBA for the quick replies!

OK, if I do this am I on the right track?:

1) Manually:

Set recovery model to Full

Do a...

If you want to be able to perform point in time restores, you should set it to full recovery mode.

Should I continue to...

Sunil Kanta (9/24/2009)

---

Exactly, I could later manage to reorder for PK index. And I did this only because i got a error while moving.

But, what for Non-Clustered Composite Index? I...

Apparently the index you tried to move was the one supporting the primary key of your table.

That index must 100% match your tables PK definition.

Altering that column sequence results in...

HTH

Just keep in mind, by switching to simple recovery, you can nolonger perform point in time recoveries !

You should revise your DRP for that db because you may need to...

another option is to move your table to its own database and then create database snapthots at your desire.

Please refer to SQL Server 2005 Books Online topic "Database Snapshots"...

Like Elliott W replied the job will not be automatically resubmitted because of a failover;

However, if the job has an active schedule or is being activated by any other means,...

Please reply at the duplicate thread : http://www.sqlservercentral.com/Forums/Topic792349-146-1.aspx

just because at this moment that thread has more replies.

Thanks.

Just hopping in 😉

The...

Edd-927544 (9/22/2009)

---

Question.

I have a SQL 2000 database with no need for anything but the simple recovery mode.

I have an ldf file that is 6 times the size of my database...

also add the db autogrowth event to your trace, that will help you determine your point of interest !

Also take into account how your applications connect and use the sproc !

What's their used Isolation Level ? ( should be "read committed" in 99.9% of the cases)

If you had searched SSC for "import errorlog"

you would have come to a lovely script "Deadlock Notifications in SQL Server 2005"

by Patrick LeBlanc ( 2007/10/10 ) which could get you...

Which parameters did you specify in your BOOT.INI file ?

BOL topic "Process Address Space" states :

If there is more than 16 GB of physical memory available on a computer, the...

I noticed if you add builtin\administrators, it gets individual auth in every database, so not...