I had to do something a little different,band that was to identify packages whose mail relay server name needed to be updated.

I ended up querying enabled jobs that call a...

How big are the databases and how long will the copy take?

Full backup must be WITH INIT option, then you have the option of using a differential.

Is your server set...

Ola Hallegren published database backup scripts

Create util database, have script as stored procedure

Use Windows scheduled task to run this

Are you calling Powershell from the SSIS package?

What about outputting the results into a sql table and populate variables with values from there?

You have already installed and configured SharePoint, you cannot change the connection string. You will have to change the alias to point to the listener

Sounds like

Update tba

Set fta1 = 'ftbid' + b.col + CONVERT(VARCHAR(2), b.orderdate, 103)

Join tbb b on tba.fid = b.fid

You deleted,/truncated a large amount of data, your database physical size does not autoshrink. Many suggest pre growing your data files. If you are certain that your database will not...

gMSA accounts are known to give errors when it comes to permissions on a network share. Do you think you could create a proxy account and use that instead

You need change control and your application needs a version table. Your application needs an about screen to show this info

The script should include the code to update the version...

What else is going on?

Xp_loginfo should not be causing such an issue.

Any blocking? Sp_who2, sp_who2 'active', dbcc inputbuffer(spid)

Sounds like a dangerous thing to do in production

Is this part of migration, a one time task or will you want your monster script to run regularly?

Sounds like your application will need 2 connection strings. One for general application and another for read only. I would create 2 application logins just to keep the separation more...

This is a tough one. Haven't heard or come across this.

What if you stop and start sql server agent services? Sounds like you have nothing to loose

Can you fail over...

Is the backup broken into several files? The backup database command has options

, Buffer count =2200, blocksize = 65536, maxtransfersize = 2097152

If that fails, use

, Buffer size =1200, blocksize =...

If your database is in standby mode, you can do a snapshot, but you cannot set a standby database online if there is a snapshot on it.

You can do a...