Viewing 2 posts - 1 through 2 (of 2 total)
If you have a budget for it, you should consider using a product like Redgate SQL Backup. It compresses your backup file as it writes it to disk. This...
March 23, 2013 at 9:58 pm
#1600102
Are you simply wanting to get the first day of the month?
SELECT DATEADD(MONTH,DATEDIFF(MONTH,0,'5/10/2012'),0)
This returns '5/1/2012'
May 10, 2012 at 7:39 pm
#1486075