New answers tagged

2

My SQL Server 2014 Express database has reached database size limit. Correct solution would be to upgrade it to version which does not have limitation on data file like developer, Standard and Enterprise depending on your requirement. If there is space in your database try shrinking it and see if that helps. But this is temporary solution in no matter ...


3

I recommend using Ola Hallengren's backup solution. The 6th question down on Ola's FAQ page walks you through automating the stored procedures with batch files. The steps given in the FAQ can be used for any stored procedure not just his. Below is the example provided from the FAQ site. You can modify that to run your custom stored procedure. sqlcmd -E -S ...



Top 50 recent answers are included