sqlserverdba
asked on
transaction log
there is a full transaction log issue sql 2000. when i looked i couldnt find any backup of the database. so if there is an emergency, should i take a full backup, followed by transaction log backup and shrink the log file?
>so if there is an emergency
this depends.. if it is a disk failure, you never gonna get a chance to do the backup
this depends.. if it is a disk failure, you never gonna get a chance to do the backup
Mmm... I differ from that comment.
There are two paths to follow when performing a database backup plan, differential and transactional, but not both of them at the same time.
I prefer to use transactional because it keeps so healthy the log file, of course to stay away from problems I do it mirrored in different places.
Remember sqlserverdba that a log backup moves the content to the backup file and then the log file get cleared.
There are two paths to follow when performing a database backup plan, differential and transactional, but not both of them at the same time.
I prefer to use transactional because it keeps so healthy the log file, of course to stay away from problems I do it mirrored in different places.
Remember sqlserverdba that a log backup moves the content to the backup file and then the log file get cleared.
ASKER
what i wanted to know was
1. during business hours in case its an emergency do i take a full backup? because there seems to be no backup whatsoever (this is an internal database).
2. So will users be affected if i take full backup, transaction log backup and possibly a shrinkfile command?. What will happen to current users and transactions?
3. because transaction log is full, do i take backups and truncate the log?
1. during business hours in case its an emergency do i take a full backup? because there seems to be no backup whatsoever (this is an internal database).
2. So will users be affected if i take full backup, transaction log backup and possibly a shrinkfile command?. What will happen to current users and transactions?
3. because transaction log is full, do i take backups and truncate the log?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
so can i just do full backup followed by log backup to free log space and dbcc shrinkfile to make the transaction log available? will any transactions be lost if i follow this process? Is it the solution to this scenario..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Full backup : one in a week
differential data backup : once per day
trnasaction log backups : at least once in 30 min