1/22/2024 10:35 AM | |
Joined: 8/3/2009 Last visit: 9/27/2024 Posts: 13803 Rating: (1741)
|
Hello hewking103 a little addition to this: a Archive segment consists of a "ldf" and and "mdf" file, so two files per segment. You should not use more that 200 single segments (about 400 files): https://support.industry.siemens.com/cs/ww/en/view/34473263 Its because the SQL Server has to attach the segments and detach it at RT Start/Stop. And this will take the most time if you have too much siingle segments. (But the advice is only a rule of thumb and always based on the complete systemperformance and th used versions and amount of data) If you have installed a SQL Server Manangement Studio on the RT System you can see live whats happening in case of RT Stop. (perhaps there are also a few segements that are stuck....) Bye Murof |
If this Information really helps, you could use the Rate function |
|
Follow us on