Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

"RESTORE..... WITH MOVE" all databases on a server Expand / Collapse
Author
Message
Posted Monday, September 24, 2007 2:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 5, 2008 2:49 PM
Points: 57, Visits: 14
Comments posted to this topic are about the item "RESTORE..... WITH MOVE" all databases on a server


Post #401893
Posted Friday, June 8, 2012 12:57 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 20, 2014 1:44 AM
Points: 68, Visits: 350
Hello,

I have some questions about your script.

I would like to restore all databases from my SLQ 2008 R2 server to a new server (no user databases on it).

If I use your SP I have to in comment the part concerning "single user" and "multi user". Is it correct ?

I have another problem to solve. Some databases contains FILESTREAM but localised on different disk (means not on the same user databases disk). How can adapt your SP to do that ?

Thanks for your help,

Eric


Post #1312905
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse