the restore would assign as owner whoever ran the restore command.

If that is not what you want use sp_changedbowner to set it after the restore completes

if this is bcp or bulk insert check out the tablock hint.

it is not possible to restore system databases to another server which is at a different patch level. You would have to upgrade the target server to be at the...

see the link in my first post for the process

Joie,

thanks for the reply. I dropped the subscriptions via the replication monitor wizard. So If I did it manually and used sp_dropsubscription that would also remove it from the subscription...

I had mentioned it earlier in the thread :ermm:

upgrade definitely do it. a migration, I've never had to.

Just thinking, on a migration or even a restore to the same server, data will have to be read from disk...

anyone want to chime in on this thread?

http://www.sqlservercentral.com/Forums/Topic856377-5-2.aspx?Update=1

Its become about people having to update statistics after doing a database backup\restore. Interested how many people do this and any insights as...

Ok, I am thinking saying that statistics are held in sysindexes might be simplistic so I have done some digging. Results so far

dbcc show_statistics in BOL says

The query optimizer stores...

yes between versions stats need redoing because of changes in the optimiser , but the same version should not be an issue.

Hmmm. Having trouble wrapping my head around this one. I hope its not true or everything I hold dear about backups turns out to be a lie. I cannot remember...

I thought Jeff was joking...

Gail,

what happened to the new years resolution to spend less time on the forums because of workload?

Still top 5 in January with over 700 posts?

Tsk, tsk. 🙂

yes, its not often I get...

check the processor busy %in perfmon (or task manager) see if they are maxed out