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

robvolk
Most Valuable Yak

USA
15688 Posts

Posted - 02/18/2011 :  17:50:36  Show Profile  Visit robvolk's Homepage  Reply with Quote
Oh man, the 2nd one in the "Get Used to Disappointments" entry is priceless.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 05/13/2011 :  12:56:07  Show Profile  Reply with Quote
No certificate password, encrypted databases are dead, Jim.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=160593


This one made me nervous enough to double check that we had backups of the certificate, private key, and password.



CODO ERGO SUM
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/23/2011 :  01:44:53  Show Profile  Reply with Quote
MDF file is missing and backup is two days old with no diff or log backups, Jim.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=162075



CODO ERGO SUM
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2165 Posts

Posted - 08/04/2011 :  08:51:49  Show Profile  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163890

I delete tables for fun!

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

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 08/04/2011 :  08:54:28  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
URLT time
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163726

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

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 08/10/2011 :  16:58:36  Show Profile  Reply with Quote
Can't restore from a differential backup without a full backup, Jim
http://www.sqlservercentral.com/Forums/Topic1157939-357-1.aspx






CODO ERGO SUM
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 11/11/2011 :  12:43:59  Show Profile  Reply with Quote
Took a full database backup and then deleted the transaction log file (LDF). Disk failed a week later, and now I want to restore from the transaction log file, Jim.
http://www.sqlservercentral.com/Forums/Topic1204174-1549-1.aspx














CODO ERGO SUM
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 11/11/2011 :  12:50:27  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Hey, look on the bright side. He has a backup.

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

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3383 Posts

Posted - 11/11/2011 :  13:00:40  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
People are being very unhelpful asking questions rather than giving him the answer.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 11/11/2011 :  13:07:54  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
quote:
Originally posted by nigelrivett

People are being very unhelpful asking questions rather than giving him the answer.


I hope you meant that as a joke.

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

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 11/11/2011 :  14:55:49  Show Profile  Reply with Quote
quote:
Originally posted by nigelrivett

People are being very unhelpful asking questions rather than giving him the answer.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.



I thought we gave him good answers:

Gail:
"...cannot recover past that last full backup that you have."

Me:
"...you are out of luck."




CODO ERGO SUM
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 11/11/2011 :  15:41:44  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
I should also mention that, up until the point he said about the deletion of the log, I was hopeful that it was recoverable. Had the log not been deleted (and the recovery model not switched to simple anywhere in the interval), that would have been recoverable right up to point of failure.

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

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3383 Posts

Posted - 11/12/2011 :  10:08:43  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
quote:
Originally posted by GilaMonster

quote:
Originally posted by nigelrivett

People are being very unhelpful asking questions rather than giving him the answer.


I hope you meant that as a joke.

--
Gail Shaw
SQL Server MVP



er - what's the other option :).

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 11/12/2011 :  11:17:49  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
I've had people tell me off for asking 'useless' questions rather than helping out, and they were being serious. One time it came with a 'if you don't know how to fix this, you shouldn't be wasting the OP's time with useless posts'

--
Gail Shaw
SQL Server MVP

Edited by - GilaMonster on 11/12/2011 11:42:03
Go to Top of Page

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3383 Posts

Posted - 11/12/2011 :  11:56:04  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
I think that was the OPs pomt of view - apart from the useless bit.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 11/14/2011 :  11:54:19  Show Profile  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=167868



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

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

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 12/01/2011 :  18:02:13  Show Profile  Reply with Quote
I accidentally restored the wrong files over my important database, but I just need you to tell me where my Backup files are Jim

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=168576

Edited by - Kristen on 12/01/2011 18:03:19
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 12/01/2011 :  18:20:36  Show Profile  Reply with Quote
quote:
Originally posted by Kristen

I accidentally restored the wrong files over my important database, but I just need you to tell me where my Backup files are Jim

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=168576




I give it a less than 1% chance that there actually is a database backup.





CODO ERGO SUM
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 12/01/2011 :  18:24:51  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
quote:
Originally posted by Michael Valentine Jones

quote:
Originally posted by Kristen

I accidentally restored the wrong files over my important database, but I just need you to tell me where my Backup files are Jim

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=168576




I give it a less than 1% chance that there actually is a database backup.


You're going as high as that?

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

Kristen
Test

United Kingdom
22431 Posts

Posted - 12/02/2011 :  04:49:46  Show Profile  Reply with Quote
"I give it a less than 1% chance"

I expect MVJ was using integer arithmetic
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.39 seconds. Powered By: Snitz Forums 2000