SQLPS depends on another module called Microsoft.SqlServer.Management.PSProvider.dll.

Importing the PSProvider module takes a very long time for me.

Incidentally, it's the source of the warning about Analysis Services.

I commented out the problem...

If you create a database and put its files on the G drive, the database will be in 'Recovery Pending' after a server restart.

It looks like SQL Server tries to...

I solved the problem thanks to Steve's suggestion. It's a hack, but it works well enough that I can run my deployment scripts unmodified.

First I created a stored procedure to...

I'm glad you asked me to try that, Jeff. It turns out that we were too optimistic about the persistence.

I restarted my workstation, started the SQL Server service, and connected...

The second step of faking a G drive was to create a named share. Its UNC path is \\localhost\MyDevDatabase.

When I pass the UNC path to xp_create_subdir like this:

EXECUTE master.sys.xp_create_subdir N'\\localhost\MyDevDatabase\MSSQL\SQLData\MyDevDatabase';

The...

Thanks for the suggestion, GSquared. I didn't know about the tablediff utility.

You can compare the jobs that exist on two servers using a command like like this:

tablediff -strict -f sysjobssync.sql...

Thanks, opc.three.

Since no-one has responded with a suggestion for an off-the-shelf solution, I guess there are none.

I'll use my script for now and run it against my server after making...

Thanks for the suggestion, Jeff. I tried that, but it doesn't behave how I would like.

When I compare the msdb database on two instances with different jobs configured, I see...