Restoring the Database

Question

Post reply

Restoring the Database

Viewing 13 posts - 16 through 27 (of 27 total)

You must be logged in to reply to this topic. Login to reply

ramana3327 SSCoach Points: 19722 More actions · Answer 1

But it is showing that the tail of the log for the database Test1 has not been backed up yet

Restoring the database terminating abnormally

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Try this instead

Restore database Test1

from disk ='\\Test\DBdumps\test1.bak

with recovery,replace

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

ramana3327 SSCoach Points: 19722 More actions · Answer 3

What is that replace option. I just use the

restore log Test1 to disk = 'd:\dbdumps\Test.bak'

It looks restore is working now. So is it mandatory to take the tail log backup before the restore

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Tail log backup is not necessary on the target before you do a restore.

The replace let's it know you are "replacing" the database with the backup you specified.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

ramana3327 SSCoach Points: 19722 More actions · Answer 5

If the Tail log backup is not necessary on the target before a restore, what could be the reason to get that error message?

After the tail log backup only the restoring is working for me.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

It is because you did not specify the replace key word.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

If this were an actual disaster recovery, then you would want a tail log backup. But that isn't the case here.

You might want to read up on a few of the options here.

http://msdn.microsoft.com/en-us/library/ms186858.aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

ramana3327 SSCoach Points: 19722 More actions · Answer 8

ramana3327

SSCoach

Points: 19722

September 23, 2014 at 6:01 pm

#1747686

Thank you

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

You're welcome

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

kevaburg SSCoach Points: 18131 More actions · Answer 10

Hi Folks,

I don't know if I should start another thread for this question but I think here is appropriate....

What happens if I perform a backup over the network and I have an outage? Will the backup continue where it left off or will it throw an error?

Regards,

Kev

kevaburg SSCoach Points: 18131 More actions · Answer 11

Hi Folks,

I don't know if I should start another thread for this question but I think here is appropriate....

What happens if I perform a backup over the network and I have an outage? Will the backup continue where it left off or will it throw an error?

Regards,

Kev

Perry Whittle SSC Guru Points: 234013 More actions · Answer 12

kevaburg (9/26/2014)
What happens if I perform a backup over the network and I have an outage?

It will fail and you'll need to restart the backup from the beginning

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

kevaburg SSCoach Points: 18131 More actions · Answer 13

Perry Whittle (9/26/2014)
kevaburg (9/26/2014)
What happens if I perform a backup over the network and I have an outage?
It will fail and you'll need to restart the backup from the beginning

Thank you Perry. That was my concern......