I think you have handled it pretty well if you are using one CHANGEID for each batch of changes.

I do like Brandie's idea of moving data to another database. It...

Restores do build files the same size as the original. That is a problem for some people, and a shrink is the way to handle this if the data will...

http://msdn.microsoft.com/en-us/library/ms365415.aspx

sp_unsetapprole

You say you are returning the ID value with an OUTPUT parameter. What do you return if you have multiple rows changed?

NULL seems like a variable to me, in an equation that can't be currently solved. Or maybe like "i". We know that it has some value, but we cannot pick...

I believe Lynn has hit on the issue. All versions prior to RTM usually only run for a limited time.

Haven't used it, but according to this blog (http://blogs.msdn.com/b/granth/archive/2008/09/23/relogging-perfmon-binary-log-files-to-sql.aspx), you should be able to write to other formats.

Keep in mind that shrinking will also fragment indexes, so after you shrank, you'd want to rebuild indexes, so allow enough free space for that.

Hyperbac technology, now Virtual Restore from...

You could, though it depends if there is anything missing in Sharepoint that people need in a file share, like automated process copies, updates, etc. I'm not sure if things...

I agree with Jeff and Gail, and also, change ntext to varchar(max)

You've listed a lot here, but it's not clear exactly what you did.

Did you run sp_help_revlogin (the 2000) version on the SQL Server 2000 server?

Did you then run the resulting...

Yes, you can script replication. Was it setup before this backup was made? Is this on a new server? If so, you might need that script to reset the jobs...

Thanks for the update. That's a good thing to check early on with the newer OSes.

I'd certainly like to try it with a camera on the crowd. I did one remote one for the Charlotte group and struggled to present to an empty room.

ESPN will do 20 people, so keep that in mind.

I'll throw out a $50 Amazon GC as a prize, maybe see if I can do a couple for top few.