andy_smith
Well Known Member
Hi List,
Anyone using SQLServer 2000 - what recovery model do you use (simple, or
full) ?
Further, does anyone use Veritas backup exec software to secure SQLServer
2000 database ?
We use backup exec and it will only backup databases that are set to be a
'full' recovery model but thats OK because we should be using that anyway.
However we have tried a restore test and were unable to restore this
database. The error we get is that the 'tail of the database transaction log
has not been backed up' so as it suggests we take a another backup of the
database but this time just a 'transaction log' backup - but after this we
still get the same error when we try to restore the database.
I am sure this is our approach that is wrong, anyone got any ideas ?
Xe SP16 Win2K, SQL2K
Andy Smith
Technical Consultant
WHITEHOUSE
Consultants
http://www.whitehouse-consult.co.uk
Office: 01564-711037
Mobile: 07949 603770
Andy Smith
Whitehouse Consultants
Win2K SQLServer7 Xe
Anyone using SQLServer 2000 - what recovery model do you use (simple, or
full) ?
Further, does anyone use Veritas backup exec software to secure SQLServer
2000 database ?
We use backup exec and it will only backup databases that are set to be a
'full' recovery model but thats OK because we should be using that anyway.
However we have tried a restore test and were unable to restore this
database. The error we get is that the 'tail of the database transaction log
has not been backed up' so as it suggests we take a another backup of the
database but this time just a 'transaction log' backup - but after this we
still get the same error when we try to restore the database.
I am sure this is our approach that is wrong, anyone got any ideas ?
Xe SP16 Win2K, SQL2K
Andy Smith
Technical Consultant
WHITEHOUSE
Consultants
http://www.whitehouse-consult.co.uk
Office: 01564-711037
Mobile: 07949 603770
Andy Smith
Whitehouse Consultants
Win2K SQLServer7 Xe