The tail backup is a way to say the "final" log backup to get the latest transactions since the diff.

As for compressing the backup, it might be worth spending the...

r_slot (4/19/2011)

---

Thanks for your code (very, very fast production - that must be a pro): for simplicity I made the same directory as you did (D:\test img\) and its running...

Thanks for helping me help YOU.

USE [tempdb]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE dbo.Renner_Foto (

[ImageID] [int] NULL,

...

We're on a rather fast san here (48 1TB drives 15 K rpm.) It would take over 100 minutes to copy 100 GB.

One way to do it is to...

So you want me to do the work for you and you won't even want to supply to tools I need to test the code? I need a zip...

Can you zip me up a couple dozens of the pictures? I'll finish the code for you.

Th eonly obvious part is that either you have a begin tran /...

CREATE SEQUENCE in SQL??? Care to catch me up Joe?

I mean copy - paste this into SSMS. Then run the code 1 line a t a time and see what works and what fails and WHY.

Repeat process untill...

Well if you actually run begin tan / rollback tran you certainly won't have anything left in the db after you run the code!

Fine, assuming the log backups are running fine.

Shrink the t-log a couple minutes before the reindexing. And see how big it grows back to after the job has run.

Even...

r_slot (4/19/2011)

---

I think your error has to do with the filepath, more specific the space in [Mijn Documenten]. If you put that piece of code between "" the problems should...

REINDEX ??????????????????????????????????????????????????????????????????????

Use a temp table (#tbl)

Truncate it and it'll reseed.

Windows admin tools, services.

Then what error are you getting on the insert when it fails?

For me I get this error :

Cannot bulk load because the file "D:\Mijn Documenten\Documents\DWCoureurLocaleData\Irfanview_26012011\1.jpg" could not be opened....