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
22191 Posts
Posted - 10/06/2006 :  07:10:36  Show Profile  Reply with Quote
I truncated my table Jim
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29138 Posts
Posted - 10/10/2006 :  07:42:53  Show Profile  Visit SwePeso's Homepage  Reply with Quote
I deleted my database and now I want to copy a table to another database.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73284


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22460 Posts
Posted - 10/10/2006 :  09:59:59  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
It is one of the Interview questions. No wonder on expecting more such related questions

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
6997 Posts
Posted - 10/12/2006 :  23:17:47  Show Profile  Reply with Quote
He got lucky, Jim.

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





CODO ERGO SUM
Go to Top of Page

jsmith8858
Dr. Cross Join

USA
7423 Posts
Posted - 10/16/2006 :  21:51:08  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
Keep an eye on this one:

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

- Jeff
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
16745 Posts
Posted - 10/16/2006 :  21:56:49  Show Profile  Reply with Quote
quote:
Originally posted by jsmith8858

Keep an eye on this one:

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

- Jeff

Boring thread

KH
Go to Top of Page

jsmith8858
Dr. Cross Join

USA
7423 Posts
Posted - 10/17/2006 :  09:16:52  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
ah .. I linked to it here after the first post .. turned out to be not as bad as I thought ....

- Jeff
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
16745 Posts
Posted - 10/17/2006 :  09:40:09  Show Profile  Reply with Quote
quote:
Originally posted by jsmith8858

ah .. I linked to it here after the first post .. turned out to be not as bad as I thought ....

- Jeff



KH
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35007 Posts
Posted - 10/18/2006 :  15:39:29  Show Profile  Visit tkizer's Homepage  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73721

Tara Kizer
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
6997 Posts
Posted - 10/18/2006 :  15:47:32  Show Profile  Reply with Quote
quote:
Originally posted by tkizer

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

Tara Kizer


If he's asking that question, there's about a 99.999% chance that he doesn't have any backups.

CODO ERGO SUM
Go to Top of Page

mr_mist
Grunnio

United Kingdom
1870 Posts
Posted - 10/20/2006 :  10:46:30  Show Profile  Visit mr_mist's Homepage  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73821

I need a versioning tool that can go back in time, Jim

-------
Moo. :)
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2111 Posts
Posted - 10/20/2006 :  13:23:29  Show Profile  Reply with Quote
Yes, he wants to use source safe or whatnot as a backup. That COULD work, but is just retarded. I think he just doesn't know what question to ask. He probably has changes he needs to make to some SPs and Tables, and don't want to test them on a test server. Once they hose the production DB, he needs to roll them back .

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
16745 Posts
Posted - 10/30/2006 :  01:01:06  Show Profile  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74191
" I dont have backup file...
I must recovery this database"

KH
Go to Top of Page

Kristen
Test

United Kingdom
22191 Posts
Posted - 10/30/2006 :  06:08:40  Show Profile  Reply with Quote
"I dont have backup file"

So how come that couldn't happen to any of us?

One of our servers wasn't running SQL Agent for a couple of days and no backups got made. The LDF grew to 12GB, none of the stale data got deleted by the daily task, there was no CPU-loading information from each minute so the "is the site busy" stuff didn't happen, lada...yada...hahahaha ....

And I thought I had a bunch of failsafe stuff in place to prevent this ....

Either

1) There was no disaster requiring recovery <Lucky!>
or
2) I was too shy to ask for help here <Unlucky!>



Kristen
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2111 Posts
Posted - 10/30/2006 :  11:23:30  Show Profile  Reply with Quote
I told him to hose his tables, Jim.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74195

Maybe not dead, but will be a nightmare to maintain.

Post count +1 hoooooo

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

mr_mist
Grunnio

United Kingdom
1870 Posts
Posted - 11/07/2006 :  06:24:47  Show Profile  Visit mr_mist's Homepage  Reply with Quote
MSDB is dead, Jim

-------
Moo. :)
Go to Top of Page

Kristen
Test

United Kingdom
22191 Posts
Posted - 11/07/2006 :  06:43:37  Show Profile  Reply with Quote
Ambiguous though ...

"i dont have the backups also.
I cant backup and restore the msdb becasuse i cant connect to msdb db now"

I read that one of two ways:

1) Typo in the first bit, backups do indeed exist.

2) "Folk have told me how useful backups are in an emergency, so I'm really keen to backup the MSDB database so that I can Restore it and all will be well"

Kristen
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
6997 Posts
Posted - 11/07/2006 :  08:10:23  Show Profile  Reply with Quote
I'm trying to kill all my databases, Jim.

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




CODO ERGO SUM
Go to Top of Page

Kristen
Test

United Kingdom
22191 Posts
Posted - 11/07/2006 :  09:12:12  Show Profile  Reply with Quote
The clue may be in the poster's Nic.:

"readysetstop"
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
6997 Posts
Posted - 11/10/2006 :  09:43:21  Show Profile  Reply with Quote
We're going back to June, Jim.

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



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