I'm referring to SAN interfaces. Dell offers SAN with either SAS, iSCSI or FC interfaces. I would like to know if anyone has used SAN with SAS interface (direct attached)....

Thanks for your answer. Yes, you understood correctly. I actually spent few hours to create this in my lab and yes, I managed to create the mirrors for three different...

worked perfectly...

Thanks a lot

I forgot to mention that this was an upgrade from SQL 2000 to SQL 2005.

however, the issue was resolved by removing SQL 2005, removing the folder manually... and then re-installing...

I got the 2nd CD...

I tried to install "Client Components" I checked all the features and as soon as I clicked Next, I got:

"The following components that you chose to...

aha.. maybe that's why.. I never got the 2nd CD ... Thanks.. I will try that....

thanks...

hmm.. sure... I will be doing few things over the weekend.. I will keep you guys posted

Thank you

Sugesh,

but this is for log file... my log file is 15 MB which is fine, my problem is the data file and not the log file...

Thanks

Hi Sugesh,

I shrinked the file.. This is the statement that I used when I did the shrinking:

USE DBNAME

DBCC SHRINKFILE (DBNAME_data)

But as...

no I didnt

is this the correct statement:

DBCC UPDATEUSAGE (mydb)

Thanks

I first deleted all the data, then re-indexed everything and finally did the shrink db...

Thanks a lot Jeff

I will try that

Hello,

How can I use BCP to write the data to a text file but quote delimited format?

Thank you

Jeff,

Thanks... your solution somehow works, but the only problem is that when I generate the file, I get this

1> 2> 3> 4> 5> 6> 7> 8> 9> 10>...