Databases are one of the most important block in today’s age of technology. About 70% of the world’s technologies relies on a database and this demand is continuously increasing. As these database structures are massively growing, it’s a good habit to take continuous backups of your data so as to recover any loss or physical damage.
In this article, i am going to show you how to take backup of your database using script files if you are using Microsoft Sql Server. Scripts files are very small in size ( almost in kb) and hence they are one, suited for this job.
1. First open your SQL Server Management Studio from Start:
2. After this, point to your database on left side inside object explorer.
Right click on your database name and choose —————> Tasks ———–> Generate scripts.
3. After clicking on the Generate scripts, a new window will pop up. Click Next.
Now it is asking you that if you want to generate script for whole database or particular tables. Choose the appropriate option and again click next.
After this choose the desired location you want your script to be saved at.
It should look like this:
4. Finally click next on the summary and then click finish.
You have finally generated your script files to save them as your backup. Enjoy.