Viewing 15 posts - 1,096 through 1,110 (of 1,318 total)
The error message in the screenshot you posted earlier was because your log file was older than your full and differential backups (it was taken before they were), so you...
April 7, 2014 at 8:28 am
The error message in the screenshot you posted earlier was because your log file was older than your full and differential backups (it was taken before they were), so you...
April 7, 2014 at 8:28 am
Hey, it's no problem :-). It's just difficult to know what's going on without being able to see it directly.
What's the situation now? Your restore of Full and Differential was...
April 7, 2014 at 7:19 am
(Sorry for all the duplicates.)
April 7, 2014 at 7:19 am
In that case your log backups were taken before your full and differential backups I think (?), which is why you can't restore them.
It's really hard to tell more from...
April 7, 2014 at 6:17 am
Ok, so they were both (Full and Differential) taken at about 4 a.m. (i.e. in the morning)?
According to your screenshot, your log backups were taken between 2 and 3...
April 7, 2014 at 5:58 am
Ok, so they were both (Full and Differential) taken at about 4 a.m. (i.e. in the morning)?
According to your screenshot, your log backups were taken between 2 and 3...
April 7, 2014 at 5:58 am
What's the timestamp of your full backup and of your differential backup?
April 7, 2014 at 4:35 am
It sounds like you're trying to restore a log file that is older than your Full or Differential backups. Check the times on all your backups and only restore logs...
April 7, 2014 at 4:03 am
Well, a backup and restore is probably simplest. You can't restore a 2000 backup straight to 2012, so do you have a 2005/2008/2008 R2 instance you can restore to first?
April 7, 2014 at 3:58 am
(Sorry; I keep generating duplicate posts.)
April 7, 2014 at 3:58 am
Ok, try this;
Alter database [your database name here]
Set restricted_user with rollback immediate
Then do
Use Master
Go
Then try your restore again.
April 7, 2014 at 3:31 am
I see you've applied the hotfix but have you set up a Windows Server Failover Cluster?
April 3, 2014 at 8:01 am
Viewing 15 posts - 1,096 through 1,110 (of 1,318 total)