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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy