Hi all,

I'm gotting this error message...

"Could not allocate space for object 'SY03400' in database 'NAME'
because 'PRIMARY' filegroup is full"

How can I resolve this...

Thanking in advance
Rino

You need to look at the drive that the Primary file group is on... physically, it is full. You either need to remove something from it or make a secondary file group on another drive. You may be able to recover some space if your log is on the same drive by doing a backup to decrease the space used and then shrink the log. Then, perhaps, move the log to another drive which will also have the benefit of increasing performance on the server overall.

--Jeff Moden

I shinked the log and it did free up space...
By moving the log to another drive would that case problem to database in anyway...

One other question...
Would I get the same error message if on the server there is a bad sector on one of the drivers... That when SQL trying to write to it it can't...

[u]Properly</u> moving the log file to another drive will only do one thing... increase performance of the server.

I suppose it is possible if you have a sector that went bad AFTER the disk space was allocated after use. It shouldn't matter before hand because SQL Server will not allocate to a known bad sector. Perhaps a run of SCANDISK from the command prompt would be appropriate to find out...

Make SURE you have a full backup of the database before you try to move the log file OR do SCANDISK.

--Jeff Moden