MSSQL Express Backup Script

There is a saying : “Better safe then sorry” well I’ve learned this the hard way a couple of times ;)…

Nowadays when I’m at a customer’s site and I have to change or do something regarding their MS SQL databases I always ask for a backup first. But sometimes the MS SQL server is a MS SQL Express or the customer doesn’t have the proper backup mechanism in place to backup the databases. Then this script comes in handy!

First you run the following query in the MS SQL Server Management Studio to create a stored procedure in MS SQL . (more…)

Read More