Take a look at the PS development tools from Idera, Quest and Sapien.

Huge push for PowerShell and yet PASS completely screwed the pooch with the lack of PowerShell sessions at this years Summit with a precon, a spotlight and another regular session.

First thing, check your backups are all good, checkdb out the wazoo and then get a hardware check run against the memory modules in your server.

The error indicates that the folder you are attempting to write the backup to does not exist. Confirm that you can access the full path yourself.

You'll need to enable TCP/IP, yes.

Here's a link to a powershell script that will take care of that for you.

Glad you're up and running.

And you've confirmed TCP/IP is enabled on the test server?

If you attempt to telnet to the test box on port 1433 do you get a connection?

Your prod server is probably listening on port 1433, meaning you don't need to provide an instance name to connect.

Your test server is probably listening on a port other than...

At the very least you'll have to have TCP 1433 opened up through the firewall for that communication to happen (that's assuming you are running a default instance of SQL...

First thing I would check given the information you've provided, is that all of the users exist in the distribution list that you are emailing. I've seen situations where there...

Good luck

Gah, hate it when that happens.

Yes, replication is recovery model agnostic. Just be aware that non-replicated transactions will prevent log reuse so can lead to log growth problems.

You can certainly schedule replication to only apply updates at certain times of the day, just be aware if you do this that it will most certainly cause your transaction...

My domain account is an administrator on the server only. I do not have domain admin permissions.

The computer object for the virtual SQL instance gets pre-created (and disabled) in active...

I'm a little unsure at your method of install. It appears as though you are logging in with the service account and then doing the install that way.

For any SQL...