Avi,

just want to say thanks for posting the script, I have over 300 databases to move and this script will be most useful. ( I have done a successful trial...

Michael Valentine Jones (9/1/2009)

---

Microsoft says that they do support an direct upgrade from 2005 Evaluation Edition to 2005 Enterprise Edition, but recommend uninstalling if you plan to go to Standard,...

information on backups is also written to the SQL errorlog, so you could check in there.

Note 2 in the following URL would suggest that you can upgrade from evaluation edition to enterprise (or any other)

http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx.

I suspect this becomes untrue once service packs have been applied?...

detaching\attaching the database can cause it to end up with a different dbid. This can affect the value of default database for the logins, so thats worth a check.

Alter database...

column loginname

sp_help_revlogin -

http://support.microsoft.com/kb/246133

as for NULL value, its the Loginname value returned in sp_helpuser, can point to an orphaned user if its NULL.

has that HR guy given an opinion on your new look yet? 🙂

This can happen if you have orphaned users and try to use the GUI, it gets confused. Usually works fine via query window so run all your create logins via...

rereading the second part of your question to mean when you first set up log shipping and the log backups were not produced via the log-shipping jobs, you would either...

winston Smith (8/27/2009)

---

Im pretty sure of this, but i want to be absolutely sure. if im running log shipping on a database, i can only have one transaction log backup...

Elliott W (8/26/2009)

---

I'm wondering if George might be onto something.. Does MS still sell 2005 or do they sell 208 with downgrade? I completely agree with everyone here,...

Only your vendor can tell you the exact terms you bought your licenses under, so only they can give you a definitive answer.

Upgrading to a new version is only free...

just wanted to point out that if using the backup\restore method to move the database files you do not need to delete\rename the database, just use the 'with move' clause...

I think its a term thats only relevant within the company you work for, and is dependant on the level of responsibility you have within the DBA team.

Factors mentioned before...