please tell me this isn't true, for every database restore, the whole of proc cache is flushed?

I have a log shipping pair set up as active\active, i.e. some databases are...

I have always run it locally no problem and prefer that, but you can run remotely I believe.

It is very light on the server, no performance hit

HTH

when restoring a SQL database the files do not need to already exist, the restore process creates them. delete any dummy files you created and run restore again.

Look up restore...

HAns,

I can think of no way to reallocate which is the primary filegroup.

possibly....

BACKUP DATABASE

add another file to the primary filegroup on your other drive

use dbcc shrinkfile(current primaryfile,emptyfile)

alter database remove file...

or this

exec sp_help tablename

......next

the with no_log option means you are merely emptying out...

if all you want to do is move the files to another drive, use detach\attach or restore database with the 'with move ' clause.

thats presuming these are user databases and...

see

http://www.sqlservercentral.com/Forums/Topic487683-8-1.aspx

Parthi, please don't cross post.

best to add user to database and add them to db_owner group. there would then be no need to give then any other rights because db_owner would cover it.

be sure...

whether dbo or just in db_owner group they will have same permissions within database, BUT see below (cut and pasted from BOL to save me typing)

The dbo is a user...

Rob Goddard (4/18/2008)

---

I'm going to throw this one out as it's beyond my understanding but looks and feels like extremely bad practice to me. Not to mention potentially dangerous.

In...

Operating system error 53 means 'the network path was not found' so looks like your path specified to backup device is wrong.

Sean,

after this particular type of shrink option the files will still be physically the same size on disk, however they will contain no data. You will know they are empty...

you cannot shrink a whole database to smaller than its original size but you can an individual file using dbcc shrinkfile rather than dbcc shrinkdatabase, so basicaly, use dbcc shrinkfile.......

see...

Vivien Xing (4/17/2008)

---

Thank you George. This clears my doubt. Bear with me one more question. How does SQL Server internally handle this?

John’s point is right....