| Author |
 Topic  |
|
Kristen
Test
United Kingdom
22191 Posts |
 Posted - 02/11/2010 : 06:19:58
|
Should be OK if you have Full Recovery Model and have never taken a TLog backup, don't you think?  |
 |
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 02/11/2010 : 08:57:12
|
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 |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 02/11/2010 : 09:21:29
|
"never taken a backup means that the DB is still in auto-truncate mode"
Foiled! |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 02/20/2010 : 02:18:54
|
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 |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 02/20/2010 : 03:00:57
|
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 |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 02/20/2010 : 03:08:21
|
| Can you tell me the 13,999,999 non-winning lottery numbers then please? |
|
|
|
DonAtWork
Flowing Fount of Yak Knowledge
2111 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 07/26/2010 : 12:27:03
|
Look on the bright side, the backups complete quickly.
--
Gail Shaw
SQL Server MVP |
|
|
|
tosscrosby
Aged Yak Warrior
USA
676 Posts |
Posted - 07/28/2010 : 08:33:51
|
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
|
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 07/28/2010 : 10:56:47
|
| And you don't need to Verify them ... no, that's not right ... |
|
|
|
webfred
Flowing Fount of Yak Knowledge
Germany
8515 Posts |
Posted - 07/28/2010 : 11:02:27
|
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. |
|
|
|
suvoraw
Starting Member
1 Posts |
Posted - 08/19/2010 : 09:14:13
|
| All people are divided on to groups: who makes backups and who will be make backups |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
|
|
madhivanan
Premature Yak Congratulator
India
22461 Posts |
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 10/06/2010 : 07:30:01
|
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 |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
|
|
Topic |
|
It's dead, Jim
