I would not recommend automating this process unless you or some other qualified person is going to be around to monitor it and ensure that SQL stops and starts okay....

Wrox also has recently published a book focused on SQL Administration using PowerShell. The first 9 chapters are PS based, but it does seem to have a focus towards SQL...

I just thought about this after I posted it. On this section:

{

if ($db -like $script)

{

It will not add anything to the $runArray as it is because the strings will not...

Try this:

#Create empty array

$runArray = @()

net use x: \\location\scripts

$scriptArray = get-childitem x:

net use x: /delete

set-location sqlserver:<dbserver>

$dbArray = get-childitem .

#Go through each script and see if it matches databases in the...

If you administer the database on the cluster, then you should be aware of the "cluster stuff" too. There are a lot of caveats with working with SQL on a...

I agree with Donald Denney on this. I went to an England PASS meeting on this two years ago, and the answer was "it depends". The biggest issue with virtualization...

GT-897544 is right. You will have to add the remote server as a linked server and then access the data on it using its four-part name.

Is this a clustered instance? Have you checked the following article?

Clustered SQL Server do's, don'ts, and basic warnings

I agree with jshailendra. You (and we) are going to need to know more information about what is going on in the job when it is failing in order to...

Nope. It audits files to the location where data files where specified to be placed during install. Your best option is to setup a script/job to move off audit files...

What error are you getting trying your method?

I do not know about using the sp you talked about, but there are some alternatives you can try. Here is a Microsoft...

Is the order that it is returning from what you can tell based on the id column, or is it showing up based on something else, like the location column?

As Bru said, you can easily do that. A single distributor can handle multiple publications. You just need to ensure that you do that - set up two distinct publications....

This might help in identifying where replication tables are hosted

System Tables

Just curious, what type of replication is this? And how long was replication down for? Because I know with merge replication if you experience replication with a subscriber go down...