How to do this in SQL Server 7.0...

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

SQL Server 6.5 \ SQL Server 7.0

How to do this in SQL Server 7.0...

Author

Topic

rem090rem
Starting Member

10 Posts

Posted - 2007-03-14 : 02:33:59

hello guys...

Please help me with this problem...

Our database is MS SQL Server 7.0, few weeks later we are encountering some corruptions of data there are some information lost but not the entire information.

So the problem is...Is it really affecting that while im editing our website DB (online) there's a big possibility that this might will happen?!

If im going to copy our DB from server to my local computer using the server DB's back-up what is the most recommended software should i use? do you think should I also use the same software SQL 7.0 and do you think it will run same as the server run's it?

any suggestions helps would be highly appreciated...

thanks in advance...hope you guys can help me ASAP...

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-14 : 02:38:00

If you are planning to run SQL Server Express on the same hardware, do you think the corruption issue is going to vanish?

Investigate the hardware to see if anything is breaking down.
Restore a backup to a new database and update the current database with the restored one's Contact Info.

Peter Larsson
Helsingborg, Sweden

rem090rem
Starting Member

10 Posts

Posted - 2007-03-14 : 03:51:37

actually the SQL Server 7.0 is in the other country, but i will try to contact the staff whose maintaining the server and tell him to check the hardware status, by the way is it connected with the corruptions of data?! and how to replace the current database with the back-up?!

well im going to copy the DB back-up to my work station which is im planning to run the SQL Server 2005 express so it is different PC.

so do you think it will run from 7.0 to 2005 express?

thanks

Kristen
Test

22859 Posts

Posted - 2007-03-14 : 05:17:57

"and this corruption happens everytime I open our DB to our server(thru remote desktop) but the user discover the corruptions 2-4 days after I edited our online website"

I will eat my hat !! if this has anything to do with SQL Server - even back at version 7 - it has proven to be rock solid for data integrity. Its going to be a hardware failure, or something else messing with SQL Servers files directly - that could be some sort of network packet corruption I suppose, in turn connected to you using Remote Connect, but I think that is very long odds.

Couple of suggestions:

1) Check the hardware - look in the Event logs (and SQL logs too) and see if there are any errors reported
2) Look for any issues from SQL Server reported by, for example, OLE components - we have had problems with 3rd party bits closely connected to SQL Server causing SQL Server to "crash" - that might induce a failure
3) Use DBCC CHECKDB to test the database regularly - that will bring to light the fact that the database is corrupted (i.e. as soon after the event that causes it as possible, which should help you "point the finger" at the cause of the problem.

"how to replace the current database with the back-up?!"

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example,Restore%20Full%20and%20all%20TLogs%20backups,Restore

"so do you think it will run from 7.0 to 2005 express?"

Yes, you can restore a SQL Server 7 backup directly into SQL Server 2005

Kristen

rem090rem
Starting Member

10 Posts

Posted - 2007-03-14 : 05:27:15

ok...thank you kristen, this could be a big help...I will post again if somethings happen...thanks again guys

rem090rem
Starting Member

10 Posts

Posted - 2007-03-14 : 07:09:51

hi,
how to use the DBCC checkdb?!

thanks in advance.

Kristen
Test

22859 Posts

Posted - 2007-03-14 : 08:07:25

"how to use the DBCC checkdb?"

Its a SQL command, just run it an examine the output. There are other parameters (such as suppressing informational messages) which you should check in BoL

Kristen

rem090rem
Starting Member

10 Posts

Posted - 2007-03-15 : 00:36:56

sorry kristen this is the first time i will use this code how or where i will put this command?! Please instruct me.

thanks for your big support to my problem...

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-15 : 00:52:10

1. Click on Start button, Run
2. Type isqlw in the dialog box
3. Provide connection information like Server name, user id and password
4. In the window, type DBCC CHECKDB '<db-name>', where <db-name> is the name of your database
5. Press F5 to run

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-15 : 01:06:05

DBCC CHECKDB ('<db_name>')

from Books OnLine

quote:

DBCC CHECKDB
Checks the allocation and structural integrity of all the objects in the specified database.

Syntax
DBCC CHECKDB
( 'database_name'
[ , NOINDEX
| { REPAIR_ALLOW_DATA_LOSS
| REPAIR_FAST
| REPAIR_REBUILD
} ]
) [ WITH { [ ALL_ERRORMSGS ]
[ , [ NO_INFOMSGS ] ]
[ , [ TABLOCK ] ]
[ , [ ESTIMATEONLY ] ]
[ , [ PHYSICAL_ONLY ] ]
}
]

rem090rem
Starting Member

10 Posts

Posted - 2007-03-16 : 02:52:31

Got it! thanks to all of you guys...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources