As @Indianrock does, I turn it on only when needed. I recall having to write a custom database archival script. Within the script a database was...

@victor: C level = company executives - those with the three letter acronyms beginning with "C" (CEO, CIO, CFO, etc.)

There are many options for obtaining the file name for an automated restore routine. You could connect to the source SQL Server directly to obtain backup metadata from msdb....

When using the Invoke-Sqlcmd, include the -Verbose option. That will output the "messages" tab from SSMS.

PS U:\> Add-PSSnapin sqlservercmdletsnapin100

PS U:\> Invoke-Sqlcmd -Query "select 'test'; PRINT N'123';" -Verbose

Column1

-------

test

VERBOSE: 123

PS U:\>

Very nice, Lowell!! Thank you!

Abu Dina (3/6/2014)

---

Gary Gwyn (3/6/2014)

---

Have you tried backing up to another attached disk on the server, then copying to USB? Or, attach the USB to your local machine or...

Have you tried backing up to another attached disk on the server, then copying to USB? Or, attach the USB to your local machine or another server. Backup...

Boy, do I feel stupid. I stand corrected. I just tested this via the GUI and a script and the change is effective immediately.

I'm not sure where I...

If no maximum is set, then SQL uses as much RAM as it needs. You can set a maximum, say 44,032 MB -- allows 4GB for OS operations. ...

Wow!!! 50,000! I script jobs frequently, but my quantity is usually much, much less. I suggest that you check to make sure the database mail profiles and...

The script will be tricky then if permissions and uncommon file paths are an issue.

If you have a linked server set up between OldServer and NewServer, then you could create...

Tom Van Harpen (6/25/2013)

---

We dont have a good solution but we do have a work around.

Basically right now we have a user that sets up jobs as themselves and once...

You can use UNC paths in the BACKUP DATABASE command. Just backup directly to the destination server, then have a script on the other end to do a restore...

Use the GUI to alter the endpoint address, or use the ALTER ENDPOINT command.

If you ever have the need to transfer the report files in bulk, then there is a great tool available that will do the work for you. I found...