How to take automatic SQL Express Server Backup?
Going to share experience about that how to take automatic backup of Microsoft SQL express by task Scheduled. As we know about Microsoft SQL express edition it's totally free that's why it has limited feature. In Microsoft SQL express edition have not feature to create job for automatic backup but still we have got to set automatic backup of SQL Express Server. Please follow below step by step to set automatic backup.
To download script and batch file for automatic SQL Express Server Backup Please click on Download.
Information and step to follow
Step 1. Copy and paste the extracted file in drive see the example below:
[c:\AutomaticSQLExpressBackup]
Step 2. Create a stored procedure in your master database:
a. Open SQL Express Server Management connect to database engine.
b. Click New Query
c. Copy all the text from [c:\AutomaticSQLExpressBackup\SQL Script] and paste it into New Query Window then click Execute ot Press F5. it should show [Command(s) completed successfully.]
d. Close SQL Esxpress Server.
Note: if you want to edit the stored procedure once it is created:
Expand Database > System Database > master > Programmability > Stored Procedure > Right click sp_BackupDatabases > Modify.
Step 3. Scheduled Task for a batch file to take Full and Differential backup:
a. Press Window+R then type Taskschd.msc.
b. Expand Task Scheduler library then create Basic Task
c. Put task name(SQLBackup) and description > Click on daily,weekly,monthly and so on according to you when do you want to task start.
d. Press Next > Click on start a program > Click on Browser and select your batch file > Finish
Note: You can edit the scheduled task according to you by double-clicking task > target > edit.
Hope this will help to all of you and resolved your all query if you have any query or question so you may ask to send email on our email account (onlinenetworkssolution@gmail.com) or leave comment on page.
0 comments:
Post a Comment