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

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 08/13/2008 :  02:57:41  Show Profile  Visit SwePeso's Homepage  Reply with Quote
What? Me worry?
I am using Microsoft Windows Server 2000. Isn't that the same as Microsoft SQL Server?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108661


Sorry for posting here but I thought this was not really a candidate for Twit list.
Rather a "I have no idea what I am working with" list.


E 12°55'05.25"
N 56°04'39.16"

Edited by - SwePeso on 08/13/2008 03:17:46
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17438 Posts

Posted - 08/13/2008 :  08:44:56  Show Profile  Reply with Quote
quote:
i use MYSQL Server 2000

It's a hybrid Server !


KH
Time is always against us

Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 09/01/2008 :  11:39:29  Show Profile  Visit SwePeso's Homepage  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109821



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/16/2008 :  00:58:38  Show Profile  Reply with Quote
I need to restore a database to a point in time but don't have any backups at all, Jim.

See last post on this thread:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=94469



CODO ERGO SUM
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 10/16/2008 :  13:37:53  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
There seems to be a fair number of these at the moment

How do I recover data without a backup.
http://www.sqlservercentral.com/Forums/Topic586427-5-1.aspx

--
Gail Shaw
SQL Server MVP

Edited by - GilaMonster on 10/16/2008 13:43:56
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 10/17/2008 :  03:45:18  Show Profile  Visit SwePeso's Homepage  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112683



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 10/17/2008 :  03:54:25  Show Profile  Reply with Quote
wow ...is he joking do we think?

Em
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 10/17/2008 :  11:26:33  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Unfortunately, I don't think he's joking. Had a similar question over at Central last week. Person stopped SQL, deleted log file and started SQL. DB came up corrupt with damage to the system tables.

Oops.

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

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 10/19/2008 :  04:50:46  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
What is it with deleting log files lately?

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

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

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 01/13/2009 :  14:04:01  Show Profile  Reply with Quote
I want to make a full backup and apply transaction logs in reverse to roll backwards to a point in time.

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








CODO ERGO SUM
Go to Top of Page

DavidChel
Constraint Violating Yak Guru

USA
474 Posts

Posted - 01/13/2009 :  14:52:46  Show Profile  Reply with Quote
Perhaps if Superman flew around the world at the speed of light a few times....
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/14/2009 :  02:09:19  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
I'm more curious how he though having only log backup (assuming they were succeeding) without the full is going to allow him to recover from a disaster.

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

tkizer
Almighty SQL Goddess

USA
35953 Posts

Posted - 01/19/2009 :  12:30:09  Show Profile  Visit tkizer's Homepage  Reply with Quote
I want to recover a database without a backup: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=118091

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

Subscribe to my blog
Go to Top of Page

Skorch
Constraint Violating Yak Guru

USA
295 Posts

Posted - 01/20/2009 :  11:06:38  Show Profile  Reply with Quote
DB is ready to die, Jim

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

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 01/29/2009 :  06:11:35  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Help me make some magic, Jim.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=118820



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3603 Posts

Posted - 01/29/2009 :  06:22:38  Show Profile  Reply with Quote
Well, hopefully its a painfull lesson..
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 01/29/2009 :  15:06:09  Show Profile  Reply with Quote
quote:
Originally posted by Peso

And that's how cookies crumble


E 12°55'05.63"
N 56°04'39.26"




Priceless!

Terry

-- Procrastinate now!
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 01/30/2009 :  01:08:43  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Oh well, just saw a Jim Carrey movie...



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 02/02/2009 :  10:07:19  Show Profile  Visit SwePeso's Homepage  Reply with Quote
File is equally large when I restore as it was when I backed it up, Jim!
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119039


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 03/16/2009 :  11:11:37  Show Profile  Reply with Quote
The whole company is dead Jim.

Mirroring is Not a Backup Solution
http://hardware.slashdot.org/article.pl?sid=09%2F01%2F02%2F1546214&from=rss
"Journalspace.com have fallen, never to return. The post on their site describes how their entire database was overwritten either through some inconceivable OS or application bug, or more likely a malicious act. Regardless of how the data was lost, their undoing appears to have been that they treated the drive mirroring as a backup and have now paid the ultimate price for not having point in time backups of the data that was their business."

Why back up? Ask JournalSpace
http://www.brentozar.com/archive/2009/01/why-back-up-ask-journalspace/





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.12 seconds. Powered By: Snitz Forums 2000