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
 Other Forums
 SQL Server 6.5 \ SQL Server 7.0
 How to do this in SQL Server 7.0...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rem090rem
Starting Member

USA
10 Posts

Posted - 03/14/2007 :  02:33:59  Show Profile  Send rem090rem a Yahoo! Message  Reply with Quote
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...

Edited by - rem090rem on 03/21/2007 04:48:36

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 03/14/2007 :  02:38:00  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Go to Top of Page

rem090rem
Starting Member

USA
10 Posts

Posted - 03/14/2007 :  03:51:37  Show Profile  Send rem090rem a Yahoo! Message  Reply with Quote
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

Edited by - rem090rem on 03/29/2007 02:17:02
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 03/14/2007 :  05:17:57  Show Profile  Reply with Quote
"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
Go to Top of Page

rem090rem
Starting Member

USA
10 Posts

Posted - 03/14/2007 :  05:27:15  Show Profile  Send rem090rem a Yahoo! Message  Reply with Quote
ok...thank you kristen, this could be a big help...I will post again if somethings happen...thanks again guys
Go to Top of Page

rem090rem
Starting Member

USA
10 Posts

Posted - 03/14/2007 :  07:09:51  Show Profile  Send rem090rem a Yahoo! Message  Reply with Quote
hi,
how to use the DBCC checkdb?!

thanks in advance.
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 03/14/2007 :  08:07:25  Show Profile  Reply with Quote
"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
Go to Top of Page

rem090rem
Starting Member

USA
10 Posts

Posted - 03/15/2007 :  00:36:56  Show Profile  Send rem090rem a Yahoo! Message  Reply with Quote
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...

Edited by - rem090rem on 03/15/2007 01:08:48
Go to Top of Page

harsh_athalye
Flowing Fount of Yak Knowledge

India
5509 Posts

Posted - 03/15/2007 :  00:52:10  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
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"
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17439 Posts

Posted - 03/15/2007 :  01:06:05  Show Profile  Reply with Quote
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 ] ]
}
]




KH

Go to Top of Page

rem090rem
Starting Member

USA
10 Posts

Posted - 03/16/2007 :  02:52:31  Show Profile  Send rem090rem a Yahoo! Message  Reply with Quote
Got it! thanks to all of you guys...
Go to Top of Page
  Previous Topic Topic Next Topic  
 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