Page 1 of 1 1
Topic Options
#126040 - 2004-09-02 10:51 AM SQL question
wizard79 Offline
Getting the hang of it

Registered: 2003-03-26
Posts: 64
Loc: Australia.
HI all,

We had a table become corrupt, so we did a repair but prob lost some data in the table. Is it possible to restore the table from a backup and place it into the db or not?

Cheers,
Jon

Top
#126041 - 2004-09-02 02:18 PM Re: SQL question
Kdyer Offline
KiX Supporter
*****

Registered: 2001-01-03
Posts: 6241
Loc: Tigard, OR
You maybe able to do this.. However, I would leverage other resources like - http://sqlteam.com .. Or, http://google.com or http://google.com/microsoft ..

Kent
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's

Top
#126042 - 2004-09-02 02:23 PM Re: SQL question
Richard H. Administrator Offline
Administrator
*****

Registered: 2000-01-24
Posts: 4946
Loc: Leatherhead, Surrey, UK
Quote:

You maybe able to do this.. However, I would leverage other resources like - http://sqlteam.com .. Or, http://google.com or http://google.com/microsoft ..





When you do you should at least specify the make and version of the SQL database engine and the backup software that you used.

Top
#126043 - 2004-09-02 02:35 PM Re: SQL question
Kdyer Offline
KiX Supporter
*****

Registered: 2001-01-03
Posts: 6241
Loc: Tigard, OR
Richard,

While we are helpful here with a good number of questions, I don't want to set the expectation that we are a fix-all shop. If it was a KiXtart question, then yes. I was trying provide helpful hints as to where to go to fix his corrupted table, torn page, etc.

Kent
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's

Top
#126044 - 2004-09-02 03:06 PM Re: SQL question
Richard H. Administrator Offline
Administrator
*****

Registered: 2000-01-24
Posts: 4946
Loc: Leatherhead, Surrey, UK
Yup, read my comment as "when you (Jon) post to a SQL support site you will want to include the information or expect to go down in flames..."

Not everyone is forgiving as us

Top
#126045 - 2004-09-03 05:27 AM Re: SQL question
Sealeopard Offline
KiX Master
*****

Registered: 2001-04-25
Posts: 11165
Loc: Boston, MA, USA
Why would you perform a table backup if the backup software cannot restore the table ?
_________________________
There are two types of vessels, submarines and targets.

Top
Page 1 of 1 1


Moderator:  Arend_, Allen, Jochen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Mart 
Hop to:
Shout Box

Who's Online
0 registered and 1046 anonymous users online.
Newest Members
Viginette, ManuvdWielNL, Sir_Barrington, batdk82, StuTheCoder
17888 Registered Users

Generated in 0.067 seconds in which 0.012 seconds were spent on a total of 12 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org