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

Primary file group out of space Expand / Collapse
Author
Message
Posted Tuesday, April 2, 2013 7:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 12:31 PM
Points: 301, Visits: 1,154
If the primary file group runs out of space and its file growth is restricted, and if the table exists on primary FG, can I still insert into this table by adding a new file on a different disk?
Post #1437878
Posted Tuesday, April 2, 2013 7:21 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:47 AM
Points: 2,137, Visits: 5,634
Yes you can.

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1437879
Posted Thursday, April 4, 2013 7:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:33 AM
Points: 2,655, Visits: 4,034
Hope you adding the new file to primary filegroup
Post #1438790
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse