I am using commvault sql ida to backup my sql databases - i'm wanting to run a post-process task that causes the t-log to shrink. i'm not very good with sql, so i'm guessing i need some type of dbcc shrinkfile command - just now sure how to create a file or bat file to execute it.
You can create a script to do it... The equivelant of the maintenance plan that is... such as a full backup :
BACKUP DATABASE <Database_Name, sysname, Database_Name> TO DISK = N'<Backup_Path,,C:\Backup\><Database_Name,
With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.
When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database.
Problems start when you try to combine that with some "user input" pass…
this article is a guided solution for most of the common server issues in server hardware tasks we are facing in our routine job works.
the topics in the following article covered are,
1) dell hardware raidlevel (Perc)
2) adding HDD
3) how t…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email
Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…