I tried to use tab limited file and the bulk insert query as

BULK INSERT designs

FROM 'D:vt.csv'

WITH

...

I think comapct edition does not allow multiple connections to same database in network.I want database to be access through network simultaneously for atleast 5 to 10 users.

I have sql server express.So SSIS is not available for me.

Here is a sample of csv file i am trying to insert

QueryResult,QueryResult,500,2,46,A,abc,1,NULL,NULL,"date_atnd,time_atnd",,70,NULL,48,NULL

Here date_atnd,time_atnd has the comma in between. So i...

thank u for replying.

I have a doubt. All my database have recovery model full. If i do file group backup separately for primary file group regularly and secondary file group...

Microsoft SQL Server Management Studio version is 10.50.1600.1

And server is sql server 2008 r2 express

I found that while i restore primary file group in ssms by using only primary file group file backup file i used following script

RESTORE DATABASE [test] FILE = N'test', ...

So shrinking only log file will not increase the fragmentation?

I used the SSMS gui option to restore the file group.

Yes, Auto close is set to true.The recovery model is full.

Thnk u anthony for your reply

But i found that this in recovery message not only comes after restarting the sql server. Sometime it comes and again goes off after 10...

Please go through these links

So log backup only reuse the space. But shrinking the log file will increase fragmentation ryt? So is it good habit to shrink the log file?