Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Repairing a SQL Datyabase		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts
Posted - 26 May 2004 :  12:37:02  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
I am having a problem with a PHP Forum and they told me repair the DB. I have never seen a option to repair a database, does anyone have any ideas?
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 26 May 2004 :  12:40:06  Show Profile  Visit HuwR's Homepage
MS SQL or MySQL ?
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts
Posted - 26 May 2004 :  14:00:31  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
MS Sql. Its using http://www.phpbb.com and for some reason certain things cant be inserted into the DB and the guys that built the software said to "Repair" the database.
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 26 May 2004 :  15:08:40  Show Profile  Visit HuwR's Homepage
in enterprise manager, right click on the db and then choose All Tasks | Maintenance plan, you can run the integrity checks and stuff from that, although I have to say the need to repair an MS SQL database is extremely uncommon.
Go to Top of Page

DavidRhodes
Senior Member

United Kingdom
1222 Posts
Posted - 26 May 2004 :  15:36:05  Show Profile
If it needs repairing it will say "Suspect" in brackets next to the the database name in EM
The UK MkIVs Forum
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts
Posted - 26 May 2004 :  15:46:26  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Ok guys thanks for your replys.
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 27 May 2004 :  06:25:02  Show Profile  Visit Gremlin's Homepage
Might pay to check it's not just out of space as well.
Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts
Posted - 27 May 2004 :  21:08:56  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
yea thats one of the first things i checked. i just have never heared of reparing a sql db so i thought i would just ask to make sure
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.37 seconds. Powered By: Snitz Forums 2000 Version 3.4.07