|Reading time|||0.11 minutes||word count|||237.6 characters|
|primary coverage|||1. Introduction & background|
|“MSSQL – single table in backup database”|
|Author||| SCscHero||Writing time||| 2021/5/16 AM2:3|
|motto||Every great cause has a trivial beginning.|
1、 Introduction & background Completion: 100%
a) Coping with problems & background
How to back up a single table in a database?
b) Solution principle & method
There are many ways to name a table name. According to my development experience and habits, I think it is necessary to make the time stamp accurate to minutes, and note the reasons for backup, so as to facilitate future work.
Select * into_ Month month day hour minute_ Backup reason] from dbo
2、 Statement and references Completion: 100%
Original blog, please do not reprint without permission.
If you have any help, you are welcome to like, collect and pay attention. If you have any questions, please comment! If you need to contact the blogger, you can directly send a private message to scscshero.