| Author |
Topic |
|
BlackReefDesigns
Starting Member
27 Posts |
 Posted - 2009-01-07 : 18:13:03
|
| Here is the situation;We currently have the website running at adxtactical.com just fine with the database.We purchased a Virtual Plan with a different hosting company, and I plugged in the adxtactical.NET domain temporarily to the Virtual Server until everything is running flawlessly - then I will switch it over to .com on the new server.Anyways, I had the Database backed up from the old Hosting Company and I restored it today onto the new server. Notice now when you go to adxtactical.net, the site is VERY slow and whenever you click on a link, I receive a Database Error. Where should I look first in finding a solution to this?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 18:26:44
|
| Do I put that in my script window and run it?And unfortunately, the error is a generic error with no form of error ID. It basically just says 'Database Connection Problem'http://www.adxtactical.net/store/pc/dbError.asp |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 18:31:36
|
| Ok, it says "Query Executed Successfully" and there is a bunch of text created. However I am still getting DB Errors on the website |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 18:43:59
|
| Remember, I am very new to this.I pasted the defrag script in the query and attempted to execute. This is what I got:Msg 2812, Level 16, State 62, Line 1Could not find stored procedure 'Tara'. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 18:48:14
|
| Now I am getting this:Msg 2714, Level 16, State 3, Procedure isp_ALTER_INDEX, Line 199There is already an object named 'isp_ALTER_INDEX' in the database. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-01-07 : 18:51:07
|
| It created it then, so now let's run it. The only things you need to change with the below are to replace DatabaseName with your database name and also to ensure that you are pointed to the database where isp_ALTER_INDEX was created. EXEC isp_ALTER_INDEX @dbName = 'DatabaseName', @statsMode = 'SAMPLED', @defragType = 'REBUILD', @minFragPercent = 10,@maxFragPercent = 100,@minRowCount = 1000Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 19:06:39
|
| Ok, I ran both of those, and they say they completed successfully! But I didn't help with the DB problems =( |
|
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2009-01-07 : 21:14:32
|
| May i know what is the error that you're getting?hey |
|
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-08 : 00:49:58
|
| hey001us, here is the exact error. It's just a generic DB error when something goes wrong with the DB:http://www.adxtactical.net/store/pc/dbError.asp |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Site running very slow after Database Restore?