Hi Jeff, it's actually a different table that I have to load the database into. I have attached an excel sheet, which should give you an idea of how the...

I have been asked by the management to provide a script for importing customer related data contained in a CSV file to a production db table next week and...

thanks for the help guys. I think I do understand a little bit about what is going on but I am still getting errors. This is what I am using...

thanks Alan, that would be very helpful.

Unfortunately, I have to do this in production. However, I will be running this query when the production is down.

Not really Alan, I want to remove the extra log files that the database has. I somehow need to make sure that the secondary log files are not being used...

I do not think I am getting right results. I compared the results from the top and bottom half of the query by changing the @fromDate to 3/1/2015 0:0:0...

It does look like the publication is working. This is what I get:

is_published

1

Yes, I am pretty sure I configured them correctly.

Well, We are running out of disk space in the production environment and I am supposed to archive some of the older backups to a shared folder located in our...

yes, that's correct.

If you don't mind, could you tell me what are some of the other ways? I would like to learn various different ways if possible.

Thanks

thank you

that's exactly my question. How do I find out which process had a role in making the log bigger?

the log files have an initial size of 512 MB. It grows in 100 MB sized chunk and the auto growth is restricted to 2 GB. Our databases are quite...