Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to find the file in user define filegroup Expand / Collapse
Author
Message
Posted Wednesday, April 17, 2013 1:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 17, 2013 6:32 AM
Points: 12, Visits: 126
Hi ,

when i used

alter database MYDB addd file
(name ='mydb_1',
filename='c:ew\mydb_1.ndf,
size=10mb,
maxsize=200mb,
filegrowth=10 mb) to filegroup FG1

then file showing in FG1

but when we add the another file then file going in primary filegroupe. I have already default filegroup assinged FG1.


Rajesh Singh
DBA(HCL Comnet)
+91-0560888360
Post #1443133
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse