FYI...Finally determined we needed to change the TDS Version from 8.0 to TDS Version 7.0 to get it to work with SQL 2012 SP3. TDS Version 8.0 had worked...

KenpoDBA,

Basing that on all our other database backups, in 2012 and 2008r2, compressing to a file less than 30% of the database size. I did try running the backup...

TDE is not enabled.

Ran the query. Thanks Perry. I changed it to add the column type (below). Mostly varchar and nvarchar, but there are a couple columns...

Not concerned about anyone connecting by accident. I don't have any problem dropping unwanted users and re-creating users/permissions. Just would prefer not to disconnect anyone who is actively using...

Thanks for the replies! As far as overlay users I mean that the source and target will have different users/permissions. If we do a backup/restore the users at...

Thanks for the replies! Going to try Phil's script. Cleaner than the one I have (easier to look at). Had kind of thought about a table before,...

Thanks for the reply. I was getting that idea. Was driving myself crazy trying to find a way to make it work, thinking there should be a way....

Check out the Free eBook called "SQL Server Tacklebox: Essential Tools and Scripts for the Day-To-Day DBA".

http://www.red-gate.com/community/books/sql-server-tacklebox

I have used Substring and Charindex to take everything after or before a character. This link gives an example...

http://stackoverflow.com/questions/11010453/get-everything-after-and-before-certain-character-in-sql-server

Are you on same machine when you try it from SSIS and SSMS? If not, could be a firewall or network issue when trying from SSIS.

If a Setup Log file was created, may want to look at that to see if there is more detailed information.

If you are looking for the day name, this will return "Monday":

select datename (dw, '2013-04-01')

John

Really? From 2010? Well, can set the the task to delete older than anything you want. Even years. 🙂

Keep in mind that you can restore...

Not familiar with Unitrends, but maybe there is some setting to truncate the logs.

Using SQL Server maintenance plans, we do a FULL backup every night and TRANSLOG backups hourly. ...

We have a maintenance plan that, among other things, runs a "History Cleanup Task". We have it set to clean up history of "Backup and Restores", "SQL Server Agent...