怎样修复SQLSERVER数据库置疑问题(doc 8页).docxVIP

下面是结果集： Databasedatabase_namestatus reset! WARNING: You must reboot SQL Server prior to accessing this database! 用 ALTER DATABASE 向数据库添加一个数据文件或日志文件: USE master GO CREATE DATABASE db_name ON ( NAME = dbname_dat1, FILENAME = D:MSSQLDatadbname_dat1.ndf, SIZE = 1000MB, FILEGROWTH = 50MB ) GO --更改该数据库以添加一个 2GB 大小的新数据文件 ALTER DATABASE db_name ADD FILE ( NAME = dbname_dat2, FILENAME = F:MSSQLDATAdbname_dat2.ndf, SIZE = 2000MB, FILEGROWTH = 50MB ) GO --更改该数据库以添加一个 1GB 大小的新日志文件 ALTER DATABASE db_name ADD LOG FILE ( NAME = db_name_log2, FILENAME = F:MSSQLDatadb_name_log2.ldf, SIZE = 1000MB, FILEGROWTH