Shulou(Shulou.com)05/31 Report--

SQL Server how to automatically backup the database on a regular basis, many novices are not very clear about this, in order to help you solve this problem, the following small series will explain in detail for everyone, there are people who need this can learn, I hope you can gain something.

1. Open SQL Server Management Studio. In Object Explorer, confirm that SQL Server Agent has been started. If not, right-click SQL Server Agent node and click Start.

Second, expand the SQL Server Agent node, right-click on the jobs folder below it, and select New Job.

3. In the pop-up "New Job" dialog box, name the job on the General tab, such as "Daily Backup NokiaWarehouseSystem."

IV. Select the "Step" tab, click the "New" button, and in the pop-up dialog box, give the step a name, such as "Direct Backup", and then in the command bar, enter the following command (here is the core of automatic backup!):

The script is as follows:

1DECLARE @fileName nvarchar(100)2SET @fileName='D:/Backup/NokiaWarehouseSystem/Backup' + CONVERT(char(10),getdate(),112) + '.bak'3PRINT 'Backup to ' + @fileName + '... '4BACKUP DATABASE [NokiaWarehouseSystem] TO DISK = @fileName WITH NOINIT , NOUNLOAD , NAME = N'NokiaWarehouseSystem reserve', NOSKIP , STATS = 10, NOFORMAT

V. Click "OK" to save the steps.

VI. Select the plan tab of "New Job"(here is the core of regular execution!), Click the New button, name the schedule, such as Daily Execution, and then make other settings, such as Daily Execution at 23:59:00, etc. Finally click OK to save the plan.

VII. In the New Job dialog box, click OK to save the job. OK!

Did reading the above help you? If you still want to have further understanding of related knowledge or read more related articles, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.