bitbucket-25253 (3/16/2010)

---

GRE (Gethyn Ellis)

Thanks for the feed back. Edited my posting to add 2 additional scripts would you be so kind as to give them a test.

Again I...

I just ran the script on my 2008 developer edition instance and it worked fine...as long as it answers the OP's question.

You can view when the stats were last updated for a particular set of stats by expanding the database in SSMS, expand the tables folder, then the statistics folder, and...

alan.young.ctr (3/16/2010)

---

I have a clustered instance of SQL Server 2008 x64 Enterprise Edition. When I run SQL Server Configuration Manager and select SQL Server Services, the window displays "Requesting...

They can coexist, so if you have SQL Server 2005 default instance, you should be able to install SQL Server 2008 along side as a named instance.

Just to add to what has been said:

When you restore the secondary logged shipped database, you have to specify the WITH MOVE statement in the restore script (there are check...

I can't find the link in BOL but think of it like this:

You have a virtual instance of SQL server that can run on one of two nodes but not...

Change them both to manual the clustering service will mange which service is started on each node. When the service is manual it won't start without an input of some...

Just to add to this post, I too have used this in the past with what sounds like a very similar configuration to Jason's and I didn't encounter a problem.

Will the server have the same name in the new domain? If not you may have to run some scripts to update the SQL Server metadata.

chrisph (3/10/2010)

---

The problem I was having was that the source DB files were located on a different drive letter (not the default location), which the destination server didn't have.

In the...

Shark

I read the first few posts of that HP forum, it seems from that they treat a 2 disk array configured as raid 10 as Raid1 which is what I...

On your server properties do you have Login auditing (at least failed logins) enabled. If you do the failed login will be logged to the error log. This will give...

I'd say you are getting that error because your DR SQL database are being logged shipped and hence in a recovering state, and users including your DR MOSS server cannot...

I have never been able to change the service account password without a restart of the service.

edit Accroding to Buck Woody's post this is not so much of a...