Two files. What are they? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Two files. What are they?

Author

Topic

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2011-08-29 : 13:36:12

What are the last 2 files and What are they for? I've never seen them before. I executed restore filelistonly to get the result.

HINGPFG1_dat I:\Data\HING\Data_HING.mdf D PRIMARY 365887488 35184372080640 1
HINGFG1F1_dat I:\Data\HING\Data_HING_1.ndf D FG1 276955136 35184372080640 3
HINGFG2F1_dat I:\Data\HING\Data_HING_2.ndf D FG2 613154816 35184372080640 4
HING_log I:\Data\HING\Data_HING_3.ldf L NULL 30343168 2199023255552 2
sysft_name_desc_watch C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\Data_HING_4.name_desc_watch0009 F PRIMARY 132982 0 65537
sysft_peplist C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\Data_HING_5.peplist000a F PRIMARY 132966 0 65538

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-08-29 : 14:18:15

Full text catalogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources