Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Full SQL backup while truncating logs

Status
Not open for further replies.
lebisol

lebisol

IS-IT--Management
Jan 3, 2003
3,325
US
Hello everyone,
I am just looking to confirm/refresh this to be the case.
Using BE 10d.
-Full backup of SQL 2000 does NOT truncate the sql transactions logs.
-Log truncating needs to be done in a separate job AFTER the full backup was compleated.
-SQL database Recovery Model needs to be set to Full.

Correct?
Thanks guys!
All the best!

:--------------------------------------:
fugitive.gif


All around in my home town,
They tryin' to track me down...
 
Status
Not open for further replies.

Similar threads

Martha_SysAdm
  • Locked
  • Question
Which hardware and software can i consider for Backup and Disaster recovery 1
Replies
3
Views
778
goombawaho
goombawaho
Kennymc
  • Locked
  • Question
backup exec
Replies
0
Views
532
Kennymc
Kennymc
Marino.
  • Locked
  • Question
Restore backup in Open VMS
Replies
0
Views
596
Marino.
Marino.
nmahat
  • Locked
  • Question
Symantec Backup Exec 2015: Backup Fail
Replies
0
Views
278
nmahat
nmahat
Phenrique
  • Locked
  • Question
ArcServe does not Exchange tape to perform Full
Replies
1
Views
259
Phenrique
Phenrique

Part and Inventory Search

Sponsor

Back
Top