New answers tagged

2

Instead of making zip file of the backup use COMPRESSION option of BACKUP command. It will compress backup and you can use it directly for restore (skipping unzip step). It is supported from SQL 2008 onward (I see you have SQL 2012) and the compression is very good (compared to compression ratio / speed). See BACKUP command for more details. You can check ...


12

Demonstrating ROI on hiring additional DBA's is hard since DBA's don't generate revenue by themselves. They do however allow the organization to function and generate revenue, just like any other supporting staff. A lack of staff in any department makes the organization function less optimal and lose money or lose opportunity. So there is a cost from lack of ...



Top 50 recent answers are included