Forum Index  ViceVersa HOME         FAQ and Knowledge Base

 FAQForum FAQ   SearchSearch Forum  RegisterRegister 
 ProfileProfile   Log inLog in 

Can't backup SQL Databases

 
Post new topic   Reply to topic     Forum Index -> Support
Author Message
CBellamy



Joined: 26 Apr 2011
Posts: 3

PostPosted: Tue Apr 26, 2011 3:09 pm    Post subject: Can't backup SQL Databases Reply with quote

We have a server running an SQL database named "SQLDB". We have ViceVersa backing up all the files in the "Microsoft SQL Server\MSSQL$SQLDB\" folder. The problem is this. It LOOKS like it's backing up, but when we load the backup on another computer, we can see that it is an old version from weeks ago. It is NOT getting an updated copy of the database. Is there an option I missed?
Back to top
TGRMN Software
Site Admin


Joined: 10 Jan 2005
Posts: 8763

PostPosted: Wed Apr 27, 2011 2:33 am    Post subject: Reply with quote

Hello,

are you using VSS ? http://www.tgrmn.com/web/kb/item33.htm

It can be activated in profile settings -> advanced settings

thanks
_________________
--
TGRMN Software Support
http://www.tgrmn.com
http://www.compareandmerge.com
Back to top
CBellamy



Joined: 26 Apr 2011
Posts: 3

PostPosted: Wed Apr 27, 2011 12:25 pm    Post subject: Yes Reply with quote

I guess I should have stated that in the original post, huh? Yes, we have VSS on. Another interesting quality that we just noticed. Neither the original files nor the backup copies of the files have recent "date modified" dates. I assume that if the backup occurs properly at least the backup copy should have a modified date of today?
Back to top
TGRMN Software
Site Admin


Joined: 10 Jan 2005
Posts: 8763

PostPosted: Wed Apr 27, 2011 1:10 pm    Post subject: Reply with quote

The issue could be due to the fact that the timestamps do not change even if the database is updated. Use this option in profile settings -> comparison

Files with these extensions are always newer in source: This option instructs ViceVersa to consider files with certain extensions to be always newer in source, so that the files are copied to the target each time regardless of their time stamp. You can specify multiple file extensions by using a separating comma (e.g. *.mdf, *.ndx). For example, Microsoft SQL database files require this option because the database file time stamps are never updated.

this option is available in version 2.5 or newer

thanks
_________________
--
TGRMN Software Support
http://www.tgrmn.com
http://www.compareandmerge.com
Back to top
CBellamy



Joined: 26 Apr 2011
Posts: 3

PostPosted: Fri Apr 29, 2011 1:15 pm    Post subject: Bingo! Reply with quote

That was EXACTLY the issue. Thanks for your help!
Back to top
TGRMN Software
Site Admin


Joined: 10 Jan 2005
Posts: 8763

PostPosted: Thu May 05, 2011 11:17 am    Post subject: Reply with quote

You are welcome! Very Happy
_________________
--
TGRMN Software Support
http://www.tgrmn.com
http://www.compareandmerge.com
Back to top
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Support All times are GMT
Page 1 of 1

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © phpBB Group
Copyright © TGRMN Software. TGRMN Software products: