This is a excellent url I have seen.It may help.

http://www.sqlskills.com/resources/whitepapers/partitioning%20in%20sql%20server%202005%20beta%20ii.htm

This drive is shared by another instance of sql(agree not a good practice) which...

This server is newly acquired from another team. So I am not sure what their trend was and this client very money sensitive for a disk addition. This application is...

Suresh,

I tried for 1gb space. It was about 35 minutes and blocked others. See my posting again.

Gail,

Will You advice any workaround to reclaim space?

In Maintenance plan, you should be provided a name conventions for your backup files. Other than this, are you expecting a logging mechanism ?

Thanks.. It worked when I used -o instead of >.

Pls have a look http://www.sqlservercentral.com/blogs/robert_davis/2009/03/04/How-do-we-handle-transaction-log-maintenance-for-a-mirrored-database/

Are you using "Max Pool Size " setting in sql connection?

http://blogs.msdn.com/b/tolong/archive/2006/11/21/max-pool-size-was-reached.aspx

Do you have any database auditing? If not, then its not possible to find out.

Depending on your edition/version and your database environment, there are many tools to capture/audit user activities.

1....

http://www.google.co.in/url?sa=t&rct=j&q=upgrade%20sql%20cluster%20to%202008%20r2%20doc&source=web&cd=4&cad=rja&ved=0CEIQFjAD&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F3%2F0%2FD%2F30DB8D46-8ACF-442A-99A2-0F4CE74AE14D%2FSQL_Server_2008_R2_Upgrade_Technical_Reference_Guide.docx&ei=VR-jUcLHCcT5rAex_IGwAw&usg=AFQjCNFbFN_E9gZKFZbyh6xaenuME_b7rw&bvm=bv.47008514,d.bmk

You cant restore ? Are you sure any of your application is connecting into ?

can you post the exact error message?

No worries. it seems worked when my developer to go for txt instead of csv.

Yes. It could be one column.

http://blogs.msdn.com/b/felixmar/archive/2011/02/14/partitioning-amp-archiving-tables-in-sql-server-part-1-the-basics.aspx

http://www.brentozar.com/archive/2013/01/sql-server-table-partitioning-tutorial-videos-and-scripts/

Partitioning is the best one if you query the partitioned columns. But in your case you want to check accountnumber where as you partitioning would be based on Year. cant...

Where does...