• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 476
  • Last Modified:

AVG alert whilst restoring a database

Hi

I'm using a web-based system to restore a database onto a database on my hosting company's server.  However, when I try to upload the DB to restore I get 2 dialog boxes popping up as attached.  I thought that maybe I had some SQL injected data in my DB that AVG was picking up but I've double-checked all tables and they are clear.  Anyone got any ideas as I need this DB up and running asap.

Thanks in anticipation.
threat-was-blocked.jpg
multiple-threat-detection.jpg
0
Lorna70
Asked:
Lorna70
  • 7
  • 3
3 Solutions
 
tlaytonCommented:
Most obvious answer is that you may have a virus on your system which has infected the .mdf / .bak file, have you tried scanning your system with something like:

Avast Free Edition

?
0
 
tlaytonCommented:
Of course to replicate the problem it may be better to use:

AVG Free Edition
0
 
Lorna70Author Commented:
I've scanned my whole computer with AVG and no problems - so very confused!!
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
tlaytonCommented:
Are you using .mdf and attaching or restoring from backup?
0
 
tlaytonCommented:
Whichever method you are using I would suggest to try the other?
0
 
tlaytonCommented:
Oops, I misread, seems you are having the problem while uploading, another workaround should be to change the extension to something like .123 and then rename the file back once it is uploaded?
0
 
Lorna70Author Commented:
It's a .bak file.  Would it be better to restore the .mdf file then instead??
0
 
tlaytonCommented:
You can try that but I would first try and change the extension from .bak to .123, upload to the hosting server and then change the extension back to .bak and restore...
0
 
Lorna70Author Commented:
Thanks but I have to do it via a 3rd party app which doesn't let me rename the DB once uploaded.  I have created a new database and it uploaded and restored fine but there a lot of tables and sprocs on the original DB I need to copy.  Is there a quick way I can generate a script to do this?  There's obviously something wrong with the DB so I only want the tables, data and sprocs.
0
 
tlaytonCommented:
Go into SQL Management Console, Right click the DB, select Tasks -> Generate Scripts...

Have a look through the options available and choose the ones right for you and it will create a script for you.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 7
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now