Server: Msg 4321, Level 16, State 1, Line 2 
Author Message
 Server: Msg 4321, Level 16, State 1, Line 2

Hello all,

I'm trying to restore selected filegroup with secondary
data file in it on MS SQL Server 7.0 following with the
sequence of transaction log backups and setting STOPAT
option for the last transaction log backup.

All backups are restored OK, except the last transaction
log backup, here I get this error:

Server: Msg 4321, Level 16, State 1, Line 2
The minimum recovery point of the database is beyond the
specified point-in-time. Reissue this statement without
specifying STOPAT.

For my scenario, I make full database backup at 10:15 AM.
Then I make transaction log backup at 10:30 AM.

Then I delete one of metatables on secondary datafile at
10:35 AM.

Then I make active transaction log backup at 10:40 AM.

When I use STOPAT option for the last transaction log
backup, this error message is returned.

Could you please advice?

Regards,

Mikhail Gvozdev



Sun, 02 May 2004 08:38:35 GMT
 Server: Msg 4321, Level 16, State 1, Line 2

I'm not sure but it seems like you try to stop at *after* the crash. Like, in your example, you
have a crash at 10.35, backup log at 10.40 and try to stop at 1.38.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...


Quote:
> Hello all,

> I'm trying to restore selected filegroup with secondary
> data file in it on MS SQL Server 7.0 following with the
> sequence of transaction log backups and setting STOPAT
> option for the last transaction log backup.

> All backups are restored OK, except the last transaction
> log backup, here I get this error:

> Server: Msg 4321, Level 16, State 1, Line 2
> The minimum recovery point of the database is beyond the
> specified point-in-time. Reissue this statement without
> specifying STOPAT.

> For my scenario, I make full database backup at 10:15 AM.
> Then I make transaction log backup at 10:30 AM.

> Then I delete one of metatables on secondary datafile at
> 10:35 AM.

> Then I make active transaction log backup at 10:40 AM.

> When I use STOPAT option for the last transaction log
> backup, this error message is returned.

> Could you please advice?

> Regards,

> Mikhail Gvozdev



Sun, 02 May 2004 19:11:38 GMT
 Server: Msg 4321, Level 16, State 1, Line 2
Hello Tibor,

Thanks for response and sorry for not responding, I was out of the office.

Strange enough, but the same strategy with exactly the same date/time stamps works OK if I use full database backup followed by sequence of transaction log backups.

I can successfully stop the restore of the last transaction log backup at required date and time, right before the "damaging" transaction.

But if I try the same tecnique with filegroup backup - no luck, the same error.

Say, I back up secondary filegroup at Nov 20 2001 11:07 AM.

Then I back up first set of transaction log at the same time.

Then I do "damage" to my database by deleting one of the tables at Nov 20 2001 11:10 AM.

Then I make the second set of transaction log backup to the same backup device at Nov 20 2001 11:15 AM.

Then I restore filegroup from filegroup backup with NORECOVERY option - works.

Then I restore the first set of transaction log backup with NORECOVERY option - works.

Then I try to restore the second set of transaction log backup using STOPAT = 'Nov, 20 2001 11:08 AM' - error 4321 pops up.

But if I use full database backup with the same technique - works OK.

What do you think can be the problem?

Thanks in advance.

Regards,

Mikhail

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Sat, 08 May 2004 08:44:50 GMT
 Server: Msg 4321, Level 16, State 1, Line 2
Quote:
> Strange enough, but the same strategy with exactly the same date/time stamps works OK if I use

full database backup followed by sequence of transaction log backups. <

That is exactly my point. You just have to accept that you cannot do point in time restore when
you do partial restore. You'd end up with some data more recent than the other data, and SQL
Server won't have that.

If you get a physical damaged file, why would you want to do a point in time restore anyhow?
Wouldn't you just restore that file and keep on working, from the latest set of data?

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...


Quote:
> Hello Tibor,

> Thanks for response and sorry for not responding, I was out of the office.

> Strange enough, but the same strategy with exactly the same date/time stamps works OK if I use

full database backup followed by sequence of transaction log backups.
Quote:

> I can successfully stop the restore of the last transaction log backup at required date and

time, right before the "damaging" transaction.
Quote:

> But if I try the same tecnique with filegroup backup - no luck, the same error.

> Say, I back up secondary filegroup at Nov 20 2001 11:07 AM.

> Then I back up first set of transaction log at the same time.

> Then I do "damage" to my database by deleting one of the tables at Nov 20 2001 11:10 AM.

> Then I make the second set of transaction log backup to the same backup device at Nov 20 2001
11:15 AM.

> Then I restore filegroup from filegroup backup with NORECOVERY option - works.

> Then I restore the first set of transaction log backup with NORECOVERY option - works.

> Then I try to restore the second set of transaction log backup using STOPAT = 'Nov, 20 2001

11:08 AM' - error 4321 pops up.

- Show quoted text -

Quote:

> But if I use full database backup with the same technique - works OK.

> What do you think can be the problem?

> Thanks in advance.

> Regards,

> Mikhail

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!



Sat, 08 May 2004 15:49:19 GMT
 Server: Msg 4321, Level 16, State 1, Line 2
Hello Tibor,

Yeah, that's what I've eventually realized. If I do partial backup, I cannot restore part of data, because it goes out of synchronization with other data files in the database.

The only situation I've found file and filegroup backups and restores usefull is critical system failure, say, when the whole data file was deleted while SQL Server was stopped.

In this case I can make active transaction log backup using NO_TRUNCATE option and then restore just missing data file and then apply all consequent transaction log backups.

Anyway, thanks for your help, it is much appreciated.

Regards,

Mikhail

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Sun, 09 May 2004 13:43:03 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

2. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

3. Server: Msg 8114, Level 16, State 1, Procedure co_AddTrader_Information, Line 0

4. Server: Msg 4425, Level 16, State 1, Line 1

5. Server: Msg 1776, Level 16, State 1, Line 1

6. Server: Msg 214, Level 16, State 2, Procedure sp_execute, Line 52

7. Server: Msg 7619, Level 16, State 1, Line 2

8. Server: Msg 7619, Level 16, State 1, Line 1

9. Server: Msg 8115, Level 16, State 2, Procedure sp_monitor, Line 94

10. Server: Msg 7354, Level 16, State 1, Line 1

11. Server: Msg 7411, Level 16, State 1, Line 1

12. Server: Msg 7399, Level 16, State 1, Line 1


 
Powered by phpBB® Forum Software