more sample data....

below data is in CSV file....

"test, test1","xyz name","some id"

"test, test1,test2","xyz name","some id"

"test","xyz name","some id"

"test, test1,test2,test3","xyz name","some id"

below data is in CSV file....

"test, test1","xyz name","some id"

I tried with SSIS it didnt work. The data are separated with double and single codes, while loading from CSV table its not getting the data in right format.However, when...

I couldnt load the data from CSV file to SQL Table in correct format, some reason your script is not converting to .xls file?

Thanks

Thanks!

We are using standard and enterprise edition 2005 and 2008 R2.

If you have a third party tools you can do instant restore with less than 5 mins outage, no matter how big is the database.

Thanks

since the log file is big, so all i need to change to simple recovery model and issue the truncate command to release the log space.

Thanks

So i need to enable AWE to user more than 1.7GB?

Actually server is 2005 32 bit enterprise and Windows server is 2003 SP2 enterprise(my understanding is 32 bit enterprise will take max memory of OS without need to enable AWE?).

Memory...

It depends. The 300 number is not a hard threshold and in my experience, on most systems you'll be well above that the majority of the time. Some things that...

Thanks you guys....

Disk space issue along the same lines i beleive backups will occur faster right since mdf file is reduced?

After shrink, fragmentation will be done....

Do i still see any advantages other...

Data is cleaned up from mdf file.so in order to get the free space to OS we need to shrinkdb right....

After shrink will it give any better performance?

Thanks

I did backup the transaction log and ran shrinkfile with truncate only but it didnt release the space yet?

Thanks

How will u generate the encryption key with third party tools?

Thanks