Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

PowerShell SCript to export almost everything from a list of servers

By Gene Hunter, 2012/02/17

Create a c:\servers.txt file and enter your server names in there.

No spaces or it wont work, enter a name, hit enter and enter another name on next line.

Then copy the contents of the script to a file ending in .ps1.

After you do that edit the file and change the $directoryfilename variableto point to where you want the files created. then just run the ps1 file as a powershell script. It will create everything in a directory structure for you.

$directoryname = "c:\downloads\DRTest\" + $server + '\' + $server

Total article views: 1376 | Views in the last 30 days: 11
 
Related Articles
FORUM

Enter data

Enter data from Ms access 2000

FORUM

Record entered date

How to find date when a record was entered

FORUM

How do I Create a stored procedure named “dropatable” that will drop a table name that is entered as a parameter if it exists.

Create a stored procedure named “dropatable” that will drop a table name that is entered as a parame...

FORUM

Enter in EM

Enter in EM

FORUM

Create server side trace.

Cannot create server side trace - error 12

 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones