SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 It's dead, Jim
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 17

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/11/2010 :  06:19:58  Show Profile  Reply with Quote
Should be OK if you have Full Recovery Model and have never taken a TLog backup, don't you think?
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 02/11/2010 :  08:57:12  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Nope.

Full recovery and never taken a backup means that the DB is still in auto-truncate mode, just as if it were in simple recovery. Log records will only be retained after the first full backup is taken.

Hence if there is no backup at all, there's no way to recover from the log. If there was a full backup, then, providing the DB is still visible in SQL, it should be possible to take a tran log backup and, if the log has not been backed up or truncated since the full it can be recovered. But it requires that first full backup.

--
Gail Shaw
SQL Server MVP

Edited by - GilaMonster on 02/11/2010 08:59:15
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/11/2010 :  09:21:29  Show Profile  Reply with Quote
"never taken a backup means that the DB is still in auto-truncate mode"

Foiled!
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/20/2010 :  02:18:54  Show Profile  Reply with Quote
RAID drive fails, replace with one of a smaller size, then use WITH DATALOSS, and then discover no tape backups for a couple of months and you have the weekend to fix it. An honest tale, but one of woe for sure

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=140178
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 02/20/2010 :  03:00:57  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Looks like I'm the prophet of doom today.

What worries me more about that is this line 'For some reason the tape backup stopped backing up the server in December'

Smells like they've been copying file system to tape. Won't help with the DB files, they'll likely be useless.

--
Gail Shaw
SQL Server MVP

Edited by - GilaMonster on 02/20/2010 03:05:42
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/20/2010 :  03:08:21  Show Profile  Reply with Quote
Can you tell me the 13,999,999 non-winning lottery numbers then please?
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 07/26/2010 :  09:28:03  Show Profile  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=147775

I am a hammerhead, Jim.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 07/26/2010 :  11:18:42  Show Profile  Reply with Quote
We're doing backups, but sending then into a black hole, Jim

http://www.sqlservercentral.com/Forums/Topic958673-357-1.aspx








CODO ERGO SUM
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 07/26/2010 :  12:27:03  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Look on the bright side, the backups complete quickly.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 07/28/2010 :  08:33:51  Show Profile  Reply with Quote
And takes up hardly any disk space!

Terry

-- A word to the wise ain't necessary - it's the stupid ones that need the advice. -- Bill Cosby
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 07/28/2010 :  10:56:47  Show Profile  Reply with Quote
And you don't need to Verify them ... no, that's not right ...
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8764 Posts

Posted - 07/28/2010 :  11:02:27  Show Profile  Visit webfred's Homepage  Reply with Quote
A backup in the morning time is better than to read my rhyme


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

suvoraw
Starting Member

1 Posts

Posted - 08/19/2010 :  09:14:13  Show Profile  Reply with Quote
All people are divided on to groups: who makes backups and who will be make backups
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/05/2010 :  12:17:21  Show Profile  Reply with Quote
For the people that never made a backup, this link might help.

DBCC Timewarp
http://www.sqlservercentral.com/Forums/Topic860953-61-1.aspx




CODO ERGO SUM
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 10/05/2010 :  13:05:43  Show Profile  Visit tkizer's Homepage  Reply with Quote
MVJ, your link redirects me to the main site. Has it been removed?


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 10/05/2010 :  13:06:33  Show Profile  Visit tkizer's Homepage  Reply with Quote
This one isn't dead, but it's very critical and corrupt: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=150954

Backups have been failing for over a year and after trying to fix them without success, they just gave up!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/05/2010 :  13:49:18  Show Profile  Reply with Quote
quote:
Originally posted by tkizer

MVJ, your link redirects me to the main site. Has it been removed?


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



Works OK for me. Maybe you're not logged in?




CODO ERGO SUM
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22754 Posts

Posted - 10/06/2010 :  05:00:56  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
quote:
Originally posted by tkizer

MVJ, your link redirects me to the main site. Has it been removed?


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog


If you are not loggedin already, you need to scroll down the page

Madhivanan

Failing to plan is Planning to fail

Edited by - madhivanan on 10/06/2010 05:01:34
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 10/06/2010 :  07:30:01  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
quote:
Originally posted by tkizer

This one isn't dead, but it's very critical and corrupt: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=150954


And not repairable. Someone's going to have a fun few days scripting, exporting and reloading....

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 12/07/2010 :  14:23:04  Show Profile  Reply with Quote
They restore over the test DB ever week, and the changes made to the test DB were wiped out by the latest restore.

No backup of test database, so how do I get my tables and procedures back, Jim?

http://www.sqlservercentral.com/Forums/Topic1030349-357-1.aspx






CODO ERGO SUM
Go to Top of Page
Page: of 17 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.59 seconds. Powered By: Snitz Forums 2000