<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 7,2000
»
Data Corruption
»
How to repair the table
30 posts, Page 2 of 3
««
1
2
3
»»
How to repair the table
Rate Topic
Display Mode
Topic Options
Author
Message
Hadrian
Hadrian
Posted Friday, July 27, 2012 10:05 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 1:28 PM
Points: 1,156,
Visits: 2,195
use backup log with no_truncate
Post #1336618
Hadrian
Hadrian
Posted Friday, July 27, 2012 10:08 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 1:28 PM
Points: 1,156,
Visits: 2,195
sorry -- backup log dbname to disk with no_truncate,norecovery
Post #1336619
Scott D. Jacobson
Scott D. Jacobson
Posted Friday, July 27, 2012 10:10 AM
Old Hand
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:17 PM
Points: 335,
Visits: 841
"NORECOVERY", no underscore.
Post #1336620
slizam
slizam
Posted Friday, July 27, 2012 10:29 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, October 04, 2012 10:49 PM
Points: 16,
Visits: 106
backup log PMSdb
to disk='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb_Log.bak'
with NO_TRUNCATE,NORECOVERY
Msg 3031, Level 16, State 1, Line 1
Option 'no_truncate' conflicts with option(s) 'norecovery'. Remove the conflicting option and reissue the statement.
backup log PMSdb
to disk='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb_Log.bak'
with NORECOVERY
Msg 3101, Level 16, State 2, Line 1
Exclusive access could not be obtained because the database is in use.
Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
Post #1336641
Lynn Pettis
Lynn Pettis
Posted Friday, July 27, 2012 11:09 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 2:45 AM
Points: 21,630,
Visits: 27,485
Scott D. Jacobson (7/27/2012)
"NORECOVERY", no underscore.
Nice catch, mistake in my typing. I should have just done a cut and paste.
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
Post #1336666
GilaMonster
GilaMonster
Posted Friday, July 27, 2012 11:59 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742,
Visits: 30,021
backup log PMSdb
to disk='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb_Log.trn'
with NO_TRUNCATE
You do not use NORECOVERY in a disaster situation (damaged or missing data file). You use it when backing up a working and online database in preparation for a restore.
Continue after error was added in SQL 2005.
Is the DB in full recovery and do you have log backups at all?
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1336690
slizam
slizam
Posted Friday, July 27, 2012 7:55 PM
Grasshopper
Group: General Forum Members
Last Login: Thursday, October 04, 2012 10:49 PM
Points: 16,
Visits: 106
when i run this...
backup log PMSdb
to disk='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb_Log.trn'
with NO_TRUNCATE
Server: Msg 3033, Level 16, State 1, Line 1
BACKUP DATABASE cannot be used on a database opened in emergency mode.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
i have no backup log...
FYI, my database (PMSdb.mdf) was corrupted before this when i attach database and the result is...
Error823: I/O error (bad page ID) detected during read at offset 0x000000e1b78000 in file
'D:\Program Files\Microsoft SQL Server\MSSQL\DATA\PMSdb.mdf'.
actually, what is the correct step?
Post #1336850
GilaMonster
GilaMonster
Posted Saturday, July 28, 2012 5:01 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742,
Visits: 30,021
If you don't have any log backups, then you'll just have to restore the last full backup that you have and accept the data since then lost
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1336904
slizam
slizam
Posted Sunday, July 29, 2012 4:14 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, October 04, 2012 10:49 PM
Points: 16,
Visits: 106
if i restore the last full backup, how about the data since then lost?
Post #1336978
GilaMonster
GilaMonster
Posted Sunday, July 29, 2012 7:00 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742,
Visits: 30,021
Was the database in full recovery model?
Do you have log backups since that last full backup?
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1336991
« Prev Topic
|
Next Topic »
30 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
