"RESTORE..... WITH MOVE" all databases on a server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Cade Bryant » "RESTORE..... WITH MOVE" all...

"RESTORE..... WITH MOVE" all databases on a server

Rate Topic

Display Mode

Topic Options

Author

Message

cadebryant

Posted Monday, September 24, 2007 2:17 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, November 05, 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

ERIC CRUDELI

Posted Friday, June 08, 2012 12:57 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 6:53 AM
Points: 49, Visits: 233

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 »

Permissions