We all need space…. Once upon a time I had a 250GB HDD, and it was back then large. Everything I needed was on that disk. But as the files grew, so did my hard got smaller. On that disk, I have lot of pictures and music, maybe some movie and bunch of documents. Suddenly …
This article shows how to create a folder for backup. The idea is to create folder with date part in its name, and then backup a specific database to that folder. First we need to create a parameters to save our SQL command in it. use master declare @sql1 nvarchar(max) declare @sql2 nvarchar(max) declare @var1 …