Jeff

can you post the actual error from the Redgate Backup log file on the server. It defaults to

c:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\instancename

this is only true for MS VS2005, under VMware...

set up column filters for the databasename (containing the object) and Textdata columns.

assuming you were catching a table called "Blobdata" set the filter on textdata to

Like %Blobdata%

install a new instance and migrate the objects then remove the old instance afterwards

once you have updated usages and indexes\stats run the following against the database

dbcc checkdb (mydatabase) with all_errormsgs, no_infomsgs, data_purity

what is the version of your sql instance?

K. Brian Kelley (12/15/2008)

---

This should be taken care of automatically thanks to the Windows Time service. The first DC (assuming it's holding the role of PDC emulator) should be set...

ensure the virtual DC's clock is constantly in sync otherwise it could become orphaned from the domain

just use the update, dont rely on the updates being correct when done in the 2000 database. When moving from SQL2000 to 2005 always update stats and usage.

when you share a folder in windows you have a share tab and a security tab. Share permissions and security permissions are different and need to be configured correctly...

update stats using

sp_updatestats

that is the option that should used

if for some reason you dont bring the logins across all is not lost

example.

database A has a user called BOB and there is a login called BOB on SQL server...

thanks m8tey, at least i learnt something at school all those years ago.

exactly my thoughts