阅读背景:

SQL Server 2005数据文件不一致(可能是8个数据文件,可能是5个,谁知道)

来源:互联网 

I have a SQL Server 2005 sp2 box where tempdb has either 8 data files or 5 data files dependingo n where you look. DBCC showfilestates and sys.database_files (both queried in tempdb) show 8 data files (tempdev - tempdev8), however when I query sys.master_files (in master db, which is also what the GUI uses), I only see 5 (tempdev, tempdev5 - tempdev8). I cannot add a tempdev2 - tempdev4 as I get an error that it already exists and I can't restart the SQL Server anytime soon to recreate tempdb.I have a SQL Server 2005 sp2 box where tempdb h




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: