thats good to hear. thanks for posting back.

William Soranno (10/16/2009)

---

I have not renamed the file. It is in the original location from installing SQL (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).

I have moved the system databases to F:\MSSQL_Data. and the...

Amit Chaudhary (9/8/2008)

---

While installing hotfix 951217 on SQL 2005, I get the folowing error :

Error Number :...

change of angle. could you possibly switch the log shipping for availability to use database mirroring, and the set up log shipping to one0_offline, restoring just once a day.

WARNING: I have not tried this.

can you go to the log shipping page of the primary database,select secondary server instance and add another secondary, which will be the same instance...

the definitive blog on this:

http://blogs.msdn.com/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx

which has a link to blog Gail posted..................

last line added by edit

Gail Knows. She keeps pre-posting me. I think she's playing with my mind. 🙂

AAAaaaaaaaaaaaaaaaaaaaargh!

Tina,

download the upgrade advisor and check out the 2000 installation.

Backout is an uninstall\reinstall SQL2000 so make sure you are in a position to do that. backup up ALL databases before...

thats what you said last time. Obviously I have failed to...

one of these days Gail I will get my reply in just BEFORE you. 🙂

San-847017 (10/15/2009)

---

Take the database OFFLINE. Go...

so stopping SQL server, moving the log to correct location and restarting did not work?

pleasure greg. nice truck.

try EXECUTE msdb.dbo.sp_start_job @job_name = 'Property Schedule'