How do i get database lost tables

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1
2
3
4
5

Home

Using DNN Platf...

Administration ...

How do i get database lost tables - Website down

5/31/2015 1:07 AM

Raja

Joined: 3/27/2009

Posts: 4

How do i get database lost tables - Website down

Hi,

There is an issue with the website http://69.67.52.39/legalmain.

First we have created a page http://69.67.52.39/legalmain/patent-search1 and redirected that to http://69.67.52.39/legalmain/Patent-Search1 page. So, it was showing an error as redirection loop. Later, when I was checking in server(SQL 2012), unfortunately "Taburl" table got deleted.

Now, the website is not opening up http://69.67.52.39/legalmain. Please check it and suggest asap.

Thanks,
Nataraja

5/31/2015 5:44 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: How do i get database lost tables - Website down

did you delete the whole table - in this case you Need to recreate
if you just removed the entries, you Need to check redirectURL in Tabs table

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

6/1/2015 6:04 AM

Raja

Joined: 3/27/2009

Posts: 4

Re: How do i get database lost tables - Website down

Hi Leupold

Thank you for the reply. We are using DNN7.3.2 version

Yeah, complete table "taburl" got deleted. I couldn't find, redirectURL in Tabs table too. Even if we recreate new "TabURL" table, its difficult to add each file manually to it(as the data is huge, and don't have a backup of it).

So, do we have recycle/restore option in SQL or can we use any third party to recover it?

Thanks,

6/1/2015 5:19 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: How do i get database lost tables - Website down

if the following statement issues an error "Table not found", when executed in Host > SQL, you are in real trouble:
select * from {databaseOwner}{objectQualifier}tabUrls
The name of the column with redirection URL is just called "URL", if it countains just a number, it is the TabID of the target page

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 1 of 1

Home

Using DNN Platf...

Administration ...

How do i get database lost tables - Website down

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)