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...

Yes indeed I am Andy.

Going to Shell Island from Sat to Tues, as my birthday get away. Should of done it last weekend but couldnt get the time off...

Quickest way to get this resolved would be to reinitialise / re-setup logshipping from a full backup.

Do not change them, they are the virtual accounts, for the accounts which run the SQL services.

Is the database in readonly/standby due to logshipping or other HA technology or have you set it like that manually?

Is the databases on a different server than the others?

Is the...

PDW can only be purchased from HP or Dell when you purchase the vendors appliance which is capable of doing PDW