Thanks Gents, been one of them days and nothing gone right so far, so my heads not in the game.

Gone with John's responce as its the simpler to impliment, just...

This is a script I call

"WhatGotRestoredFromWhereWhenAndByWho"

SELECT

DatabaseRestoredTo = RH.destination_database_name,

TimeOfRestore = RH.restore_date,

UserImplimentingRestore = RH.user_name,

RestoreType = CASE RH.restore_type WHEN 'D' THEN 'Full DB Restore'

WHEN 'F' THEN 'File Restore'

WHEN 'G' THEN 'Filegroup Restore'

WHEN 'I'...

I would change the UploadDate to a date in the where clause and do a comparision that way

SELECT

*

FROM

MyTable

WHERE

CONVERT(DATE,UploadDate) = '2012-07-18'

Do you have the /PAE switch in the boot.ini file? If not it needs adding in.

You will need to enable AWE and set lock pages in memory as its...

Can you post the DDL of the view and tables in question?

Along with the data for row 123456

Does seem strange the it only works on a like and not =

Yeah it is a pain that, but mm is minutes, MM is month.

So if we take the a usual standard date format in SQL it would look like this...

You will need to follow the whole restore process again

Full NoRecovery

Diff NoRecovery

TX NoRecovery

TX NoRecovery

TX NoRecovery

TX Recovery, STOPAT '2012-07-26 13:05:00'

Once the DB has been put into recovery you cannot apply any...

How do you mean iterate the timings?

Do you mean restore to 13:00, then restore to 13:05, then restore to 13:10 etc

Use a format expression around the date field

=Format(Fields!DateField.Value, "ddMMyyyy")

I've seen that as well Tom, just not brought myself to try it yet.

I think it might be time to get some for the weekend and see if it is...

Find where the data source(s) is/are on your SSRS server and change the authentication method to integrated security.

You would usually do this in BIDS before you deploy the reports to...

Oh I will, as long as the weather is nice, been checking every day, now its forcasting rain all weekend, not impressed.

Hi

Welcome to SSC.

Thanks for the query that will help us sortly in hopefully answering your question.

But first could you please take a look through the second link in my signature...

Damn, got 3 out of the 4, I thought mirroring wouldn't of been true as it is now a depreciated feature so, wouldn't of thought the two would co-exist.

They are nammed differently in 2008 but they still have SA rights, they are required for the correct operation of SQL.

You shouldnt tamper with these as SQL creates the ACL's...