Just to add my thoughts here:

Brent does have some good material on the advantages and disadvantages of Virtualisation and a bunch of other posts, check them out here:

http://www.brentozar.com/sql/virtualization-best-practices/

I have a...

It appears so, the proxy can see the file and open it, its only reading from it so I guess that should be enough...I will quadruple check tomorrow though, it...

As Jeff has said the upgrade advisor will assist you in identifying what changes you need to make before and after an upgrade.

SQL Buddy is right AWe is not needed on 64 bit systems, if you intend to lock pages in memory then you need apply a CU to SQL Server 2005...

The only real way to tell if a backup is good is to restore the file.

I think I have it fixed, it looks like the install was trying to create to temporary file on the D:\ drive which is my vCD/vDVD which had the ISO...

Was a restore taking place when the reboot happened?

A database in a restoring state usually indicates that a restore has taken place with the NO RECOVERY OPTION specified usually so...

The restore procerss is fully documented in BOL

You to take a tail log backup so you capture all entries currently in the transaction log that have not been backed up.

You...

You need to establish why the database is unavailable, is there anything in the SQL Server log or event viewer that suggests why it is unavailable. You can try the...

where do you buy your licenses from? They will be able to tell you.

Can you provide some table structures and sample data?

Paul, is there a 'report' feature of the new syntax...I can't see anything in BOL

an equivalent of sp_change_users_login 'report' ?

hydbadrose (3/22/2010)

---

sp_change_users_login 'update_one', 'dbo', 'dbo'

I get an error message stating that 'dbo' is a forbidden value for the login

parameter in this procedure. How to fix this orphan id? Please...

I'm not all that familiar with licensing but if you are moving up a version surely you have to pay for new licenses, you can't just use the 2005 licenses...

You need to idenify the features available in the enterprise edition of SQL 2005 that you make use of that are not available in SQL 2008 standard edition and work...