you would have to do the restores in norecovery mode. As soon as you failed over and bought the secondary online the databases would get upgraded. You would then not...

As I understand it you are only doing this to separate data from log? I would seriously consider, in fact recommend, only moving the user databases and perhaps tempdb,...

it will have whatever rights are granted to public, we can only surmise that is all the app requires.

It has been granted view any definition so will be able...

well - sysadmin - no only joking, don't do that 🙂

that script will add the user to model as well, so all new databases would automatically get the user as...

John Mitchell-245523 (1/21/2014)

---

But you don't want it running against databases that don't have the tables - that would be a waste of resources. That's why I suggested scripting it...

no problem

never, never backup multiple database to one device. Would make finding the correct backup for a restore a nightmare. Also if you lose that device you lose all your backups.

I...

is the table a heap (indid = 0). rebuild would not be able to defragment a heap.

database permissions are held within the database, so will be taken over with the database restore.

Scripts above only deal with the logins, but as they take the sids with them,...

Nice script Perry, if you don't mind a small improvement to cover cases where the parent table is in a different schema

SELECT'The table ' + QUOTENAME(SCHEMA_NAME(k.schema_id)) + '.' +

...

as perry says - doggy doo doo. For sql authenticated...

Perry Whittle (1/20/2014)

---

SQL_Surfer (1/17/2014)

---

I need to copy some databases from one server to another. What is the best way to copy logins with their passwords? Each login has access to...

the version for 2005 and 2008 is the same.(but different from the 2000 version)

you can still shrink it if thats what you mean.

If the log is growing because communication with the mirror is lost, then if you cannot reestablish mirroring you will have...

did you run updateusage before the spaceused.

How did this database come to have so much freespace? Were variable length columns dropped?