事务过程中作checkpoint写数据到哪里？文件组中数据是同时写到几个文件中？那么备份时如何选择备份哪些文件 ？

[redpop]

？

[welyngj]

1。数据文件
3。for example:
backup database msdb filegroup='primary' to disk='d:\a.bkp'

[welyngj]

备份特定的文件或文件组：

BACKUP DATABASE { database_name | @database_name_var }
< file_or_filegroup > [ ,...n ]
TO < backup_device > [ ,...n ]
[ WITH
[ BLOCKSIZE = { blocksize | @blocksize_variable } ]
[ [ , ] DESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] DIFFERENTIAL ]
[ [ , ] EXPIREDATE = { date | @date_var }
| RETAINDAYS = { days | @days_var } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] FORMAT | NOFORMAT ]
[ [ , ] { INIT | NOINIT } ]
[ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] NAME = { backup_set_name | @backup_set_name_var } ]
[ [ , ] { NOSKIP | SKIP } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]

[redpop]

文件组中数据是如何写的 ？

[redpop]

文件组中数据是如何写的 ？

[redpop]

文件组中数据是如何写的 ？

[elite2018]

mdf store system data, ndf store normal data

[pengdali]

当一个写满后写下一个