A silly mistake happens to all of us every once in a while and with some even more frequent 😉

Please provide the feedback on the backup creation script and the...

How did you split the backup files ?

Can you post your actual backup statement ?

If you used

BACKUP DATABASE AdventureWorks

TO DISK='X:\SQLServerBackups\AdventureWorks1.bak',

DISK='Y:\SQLServerBackups\AdventureWorks2.bak',

DISK='Z:\SQLServerBackups\AdventureWorks3.bak'

I would try this on a test system

RESTORE...

If you have default trace active, this will certainly help you filtering what to trace.

Did we have recent autogrow? by Tibor Karaszi

http://sqlblog.com/blogs/tibor_karaszi/archive/2008/06/19/did-we-have-recent-autogrow.aspx

I hope you can find your hacker using...

/*

DBA_FailedConnectionTracker: Maintain an overview of which connections are made to this SQLServer instance

-- This implementation user SQLServer Service Brocker with Event Notifications

*/

USE YourAuditDB;

if...

Check your sqlinstance errorlog, it may contain messages of your activation procedure !

Maybe these scripts can help you find the issue.

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/

Helical Johan (1/7/2011)

I have a job for generate a backup in the server A.

I must put the file in other server (B).

1. net use \\10.16.500.222\v3_bak\CC /user:domain\user ...

Create table #tmpRegValues ([Value] varchar(50), [Data] varchar(1000))

insert into #tmpRegValues

exec master..xp_instance_regenumvalues N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters'

Select @LogFolderName = substring(Data, 3,datalength(Data) - charindex('\',reverse(Data)) - 2)

from #tmpRegValues

where Data like '-e%'

no.

You need to test it for your configuration and situation.

But to comfort you a bit, they did already launch CU1 for SP4.

They did chose number of characters to be the third part of the substring function.

That's just a convention.

In the other case, there would also have been users complaining...

Space shuttle also has 5 on board computers.

Let me be number 5...

Based on your last info, I would say to fall back to full set comparisson:

This way you compare all columns of the rows of the set.

Keep in mind columns are...

Ah ... I should have known that :blush:

Indeed, Antwerp was a mess this morning. Slippery roads and unadapted driving style causing "fun" traffic jams all over the place 🙁

Regarding the pastries, I was aiming for the theme...

Koen (da-zero) (1/9/2011)

Tom.Thomson (1/9/2011)

?? :ermm:

Do you Americans work to 14th night instead of...

Keep in mind there may be non-related rows that have the same

Bedrag, Boekdatum and Omschrijving1, but belong to a different account.

SELECT Rekening

,...