Is that the exact output from sys.indexes, with the case of the index names...

One way to speed up the preprocessing of your CSV files is to use Log Parser to convert them to TSV files. A TSV should be easier for SSIS...

Hi Bea,

It could be that the VM's time is drifting enough during the backup. Which in turn could cause some authentication related issues.

For some troubleshooting steps related to timekeeping:...

Hi Phil,

Since you used Process Explorer you might want to consider Process Monitor.

The key is to enable filtering for file activity only, configure it to drop filtered events and...

Hi Paul,

The server doesn't timeout when running a query (linked servers aside). It's the client that tells the server to cancel a query based on its command timeout value....

Hi Jörg,

Here's one way to get the binary value from the string as long as it looks like S-1-5-21-aaaaa-bbbbb-ccccc-ddddd.

/*

S = security identifier

1 = revision 1 of the...

Backing up the SMK, DMK and certificates isn't required for a backup/restore situation.

A) No additional steps required after restoring the database.

B) Allow the SMK to open the DMK after the...

I think you're close.

Rather than creating a certificate with the same name in both databases you should backup the certificate from the first database and restore that to the...

Here's where you'd find that for SSMS with 2005.

[font="Courier New"]\HKCU\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\Open Find\Places\UserDefinedPlaces[/font]

Add subkeys Place0,Place1,Place(n)

Under each subkey add two REG_SZ values

[font="Courier New"]Name = "Shortcut Name"

Path = "Folder location"[/font]

You might be able to find out when it happened using the fn_dblog function.

SELECT [transaction id],[begin time],[spid],[allocunitname],[operation]

FROM fn_dblog(NULL,NULL)

--WHERE operation='LOP_DELETE_ROWS'

--WHERE [transaction id]='0000:00027a0a'

Have a look at Robust Copy (robocopy); downloadable as part of a Windows resource kit. By default that will not overwrite files at the destination.

[font="Courier New"]robocopy e:\Backup-Location\ \\ServerA\NetworkShareName *.bak[/font]

Or,...

Could be wrong but I thought SQL Express had Autoclose as a default option.

If that's the case then changing Autoclose on each database from True to False should prevent...

How did you configure the error output? Did you change it to redirect or ignore for every column?

You could post your .DTSX file and a sample input file that...

You could add another destination for the errors. For example, add a flat file destination, connect the red line from the source to that and reconfigure the Error Output...

After the trace has been running for awhile stop it by setting the trace status as Perry had shown in a previous post.

You are probably thinking of DTA, Database Engine...