Site Log and SQL - Administration and Configuration

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

9/16/2010 6:54 PM

kcsurfer

Joined: 2/21/2007

Posts: 56

Site Log and SQL

I accidentally used the Truncate command for the DOTNETNUKE table in SQL. It cleared out the SITE LOGs in DNN. I was doing it to resolve some performance issues of the site. Now, I would like to restore the Site Logs back. I have backups of the Windows server for the last 7 days (entire image).

What would I need to restore from a previous image to restore these logs?

9/16/2010 7:53 PM

Sebastian Leupold

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

Posts: 46212

Re: Site Log and SQL

do you have a backup of the DNN database? restore it to a different name and use insert statement to copy over rows from one table to the other.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

9/16/2010 9:46 PM

kcsurfer

Joined: 2/21/2007

Posts: 56

Re: Site Log and SQL

Sebastian Leupold wrote:
do you have a backup of the DNN database? restore it to a different name and use insert statement to copy over rows from one table to the other.

Hi Sebastian, Thank you for your response. I am not very confident working with databases. I have the image of the whole server so I am sure I have a backup of the database. Can you tell me how to restore the database to a different name? I am sure how to copy over rows from one table/database to another either.

9/17/2010 6:01 AM

Sebastian Leupold

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

Posts: 46212

Re: Site Log and SQL

you need to setup the image of your backup separately and may export sitelog data (e.g. using MS access) and add it to the sitelog table of the other server. I don't see another chance accessing the data inside.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 1 of 1

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)