August 10, 2010 at 11:47 pm
I have a doubt but it may be simple . pls help me . i created a database in my server and created the .mdf , .ndf and .ldf in the path c:\program files\..\data\...
after this i tried to create another .ndf file manually using qlter database statement without specifying any path . because it shows error when specifying the path . the .ndf file gets created when i give
alter database
add filegroupname group_name
but after creation , i cannot find this file in any path . even after searching the entrie memory . but if i excute the query again it shows already exists . pls help me out in it .
August 10, 2010 at 11:56 pm
You need to add a file to the new filegroup:
ALTER DATABASE <DB_NAME>
ADD FILE
(
NAME = <FILE_NAME>,
FILENAME = '<path>',
SIZE = <xMB>,
MAXSIZE = <xMB>,
FILEGROWTH = <xMB>
) TO FILEGROUP <FILEGROUP NAME>
August 11, 2010 at 4:14 am
In case you need to figure out if the file was already created, or if you simply want to find the location of the ndf, then simply run the sp_help <dbname> command in the query window.
That should point you to the actual position of your missing ndf file, if it was created.
August 11, 2010 at 4:14 am
eh.. that was the sp_helpdb <dbname> in the previous post..
my bad...
August 11, 2010 at 5:31 am
or u can use
SELECT * FROM SYSFILES
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply