are your distmdl files in the same location as your master database files? If they are not this can cause patches to fail.

there have been posts on this on this...

am i totally missing something here, but if running queries in QA surely:

ctrl T, ctrl E - results in text

ctrl D,ctrl E -...

do you do an index rebuild or a reorg. If a reorg this does not update your stats, rebuild does.

Either way, as this is a busy database it sounds like...

it retains the settings from those you set via the alter database command

then they are probably not backing up the logs.

even if they are using backup exec to back the databases up to tape I would still have backups on disk, space...

you say you switched auto update statistics ON then OFF? Is that on just before the process and off again afterward?

If so suggests you have auto update stats off by...

only way out of this is to run the restore again through to completion.

lowell, you're a star. many thanks.

george

thanks chris, that did it. The actual difference was I did not have quotes around the output file either, adding those makes it work.

I'll post the script to this site,...

I have tried double quotes, square brackets and curly barackets, all to no effect.

I would really like to get this working for DR purposes and because I have seen anumber...

have I flummoxed the SQL world again or is the question not clear?

you don't need to copy packages to the file system to amend them, but if you want to copy packages use utility DTUTIL

the following reverse engineers the code to re-apply all server roles granted to logins:

set quoted_identifier off

set nocount on

select 'exec sp_addsrvrolemember ' +"'" +loginname +"',"

+"'sysadmin'"

from syslogins where sysadmin =...

check to see if autoshrink option ticked on the database. (In EM, right click database, properties, options).If it is and this is a production database, un-tick it

if you leave an install to 'default' (don't go into advanced option) system dbs end up in c:\program fies.

for an upgrade, the default will be wherever the registry says your...