MSSQL · single table in backup database

Time:2021-6-10
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
Article type |Series Completion |Completed
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.