Author |
Message |
CBellamy
Joined: 26 Apr 2011 Posts: 3
|
Posted: Tue Apr 26, 2011 3:09 pm Post subject: Can't backup SQL Databases |
|
|
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: 8759
|
|
Back to top |
|
|
CBellamy
Joined: 26 Apr 2011 Posts: 3
|
Posted: Wed Apr 27, 2011 12:25 pm Post subject: Yes |
|
|
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: 8759
|
Posted: Wed Apr 27, 2011 1:10 pm Post subject: |
|
|
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
|
Posted: Fri Apr 29, 2011 1:15 pm Post subject: Bingo! |
|
|
That was EXACTLY the issue. Thanks for your help! |
|
Back to top |
|
|
TGRMN Software Site Admin
Joined: 10 Jan 2005 Posts: 8759
|
|
Back to top |
|
|
|