where databasepropertyex([name], 'recovery') in ('FULL','BULK_LOGGED')

If you have enterprise edition maybe partitioning the table will work for you, else you probably want to go with a crawler delete to avoid blowing the log and reduce...

On the question of the price increases I asked my purchasing guys if I could avoid these by not downloading R2 but using 2008 SP1 instead. they said I would...

the .tuf file would be kept in the same location as .trn files on the destination server.

Jeff Moden (2/6/2010)

---

The Dixie Flatline (2/6/2010)

---

Thank you for that helpful information, George. I apologize.

Can someone tell me if it makes a difference whether or not the new servers...

Lutz, if you haven't got a backup of your keyboard we can't help you.

dixie Bob, we are saintly here at SSC and have infinite patience,we know if shown the error...

thats leading on to moving the resource database. The master and resource databases should be kept together.

do yourself a big favour, move the master log file back where it was...

The Dixie Flatline (2/6/2010)

---

Totally different question: We still have to support some old tired iron that was never upgraded with Penning Traps because management didn't want to...

A word of warning, I successfully migrated to a VM using parameter 111 (thanks Jason), but in doing so I must have crossed a time period where some logins were...

why?

Thanks Jason, I'll give parm 111 a try.

thats why I love SSC, you can always learn something new and useful.

BTW, if copying to Oracle, you need -T666 in the startup...

Lutz, microsoft don't recommend it but with careful use of the additional parameters you mention plus 101 - 110 to recover corruption in system databases DBCC timewarp can be used...

just to confirm it I tried to restore an msdb database from a 2005 SP2 server (3042) onto an SP3 server (4035) - i.e. lower version to higher, and got...

probably blank because SQL cannot resolve ID of whoever ran restore, either way sp_changedbowner should fix it.

Bru Medishetty (2/5/2010)

---

Remember that a backup of a lower version / patch level would work when tried to restore on a higher version / patch level. But the higher version...