Using management studio, run these to check on the current space used. You should see a difference if there is an increase in data. If you know some...

Not ideal as merging partitions would be an IO intensive operation, you would be better off keeping the extra partitions.

S_Kumar_S...

The point is you cannot apply transaction log backups to an OS level disk snapshot as suggested in the original post.

Gary Bourne-389258 (5/18/2012)

---

We are therefore also looking a O/S...

Lowell (5/18/2012)

---

MysteryJimbo (5/18/2012)

---

the knee-jerk reactions to cursors and xp_cmdshell have their place, but...

Lowell (5/18/2012)

---

I'll go all devils advocate on the SSIS guys and present a solution i put together for other posts that is all TSQL.

Thsi requires xp_cmdshell to get the list...

I'm not sure if Im being clear enough on the terminology....

The easiest way is simply to use these parameters from send_dbmail.

@query = 'SELECT * FROM @tablevariable'

,@attach_query_result_as_file = 1

http://msdn.microsoft.com/en-us/library/ms190307.aspx

Jeffrey Williams 3188 (5/18/2012)

---

SAN level snapshots will work - if they are done correctly and managed by the SAN vendors software it is very likely you will have the ability...

Pinal Dave has done a useful one for a single file

http://blog.sqlauthority.com/2011/05/12/sql-server-import-csv-file-into-database-table-using-ssis/%5B/url%5D

There are several references for using a for each container. This is the first one from google.

http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx

So the theory...

tt-615680 (5/18/2012)

---

Thank you for your reply!

While the Database was set to Full Recovery, I run the following script

INSERT INTO NewTable

(

column1,

column2

)

SELECT

column1,

column2

FROM

table1 app

INNER JOIN table2...

ByronOne (5/18/2012)

---

Hi everyone

I have a number of csv files in one folder location. I would like to import them into a single SQL Table. What would be the method...

Just to be clear we are talking SQL instances running on Windows clusters.

You can multiple instances running on a single Windows cluster. Easily achieved and completely configurable.

I would...

You're only options is to manage the log file by backups, simple mode or a code rewrite.

Switching to simple mode will only help if you import method uses individual transactions...

You can also set up a table valued parameter for passing between stored procedures and UDF's.

Our weekly 5TB database backup completes in 5 hours. The daily differentials complete in around 40 minutes. 5 minute Transaction log backups complete in around 20-40 seconds.

Data used grows...