Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transaction Log
Message
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Transaction Log
Divers
Thread ID:
00637785
Message ID:
00637785
Vues:
57
This will sound dumb, but I'm coming from Oracle and SQL Server is about 30 days old for me :-)

In Oralce, I'm used to the following:
Multiple log files that are used in a circular fashion.
These log files are required for recovery (last trx) along with the backup.
Another process (archiver) copies those log files so each log is kept.
...

My undertstanding of the SQL Server Trx log is that it's similar in the way it stores a journal of the DB DML's. But there is only one, no circular list. (correct me if I'm wrong)

Here is my question (finally)

I do a complete backup of the DB, then a TRXLog backup, schrink the DB and the TRXLOG is still the same... (100Mb, originally created at 10Mb).

What am I missing here ?

Thanks!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform