Error while backing up of Table

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  September 22, 2004 at 5:54 am

  #84194

  i am getting following error while backing of my table .

  should i create secondary file ,and if i create then will it start working automatically?

  Please suggest.

  Msg 1105, Level 17, State 2, Server production, Line 87

  Could not allocate space for object 'BACKUP' in database 'Trans' because the 'PRIMARY' filegroup is full.

   

  Thanks

   

• jordanac

  Hall of Fame

  Points: 3653

  More actions

  September 22, 2004 at 6:24 am

  #523958

  Hi ,

  On a default installation of SQL Server all of your drives are on "PRIMARY" filegroup. eg. (a: d: e  This error means that where you are trying to put your backup file that that Drive is full. Eg. drive d:  

  "Maybe I did not read your post correctly" If you are creating a backup of a TABLE with T SQL then your trans database datafile / log is on a full disk. you can create a secondary mdf file on another drive. 

  
  Andy.

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  September 22, 2004 at 9:39 am

  #524019

  Below is what i understood from your post

  I am getting following error while backing of my table

  Ans. SQL Server does not have a feature which will allow you to back up only one table.

  Regarding  error,

  Msg 1105, Level 17, State 2, Server production, Line 87

  This states that your primary file group is full. The reason for this might be that you are running out of space. You can add a file to the same filegroup and this should take care of it. If you have space on the harddrive, check to see if the size of the file has been restricted.