Eprs_Admin
asked on
SQL DB full with logs
Hi Experts,
we have several DB´s on a SQL Cluster.
But all logs go to the same log file.
Is it right ?
And how to clean up all the transaction logs ?
we have several DB´s on a SQL Cluster.
But all logs go to the same log file.
Is it right ?
And how to clean up all the transaction logs ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
when I have 270GB of logfiles, how to avoid this big data ?
When the backup is done all logfiles are at zero again ?
When the backup is done all logfiles are at zero again ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok thanks I will go for 2 hourly incremental backups after the full.
ASKER
But what can I do with the rest of the transaction logs ?
I still have 200 GB logs after the full backup was successful and the incrementals also successful.
How to force the SQL to write all these pages to the DB ?
I still have 200 GB logs after the full backup was successful and the incrementals also successful.
How to force the SQL to write all these pages to the DB ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
First I make a full backup, daily.
Then I want to do each 3 hours an incremental backup METHOD LOGS.
And one more incremental backup each 3 hours METHOD DIFFERENTIAL.
But now I still have 200GB of log files and I want to get rid of it.
But I will not loose any data.
Then I want to do each 3 hours an incremental backup METHOD LOGS.
And one more incremental backup each 3 hours METHOD DIFFERENTIAL.
But now I still have 200GB of log files and I want to get rid of it.
But I will not loose any data.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi first of all to the log and differential method.
Symantec write this to each SQL Backup job.
You have to create one full and two incremental jobs.
Now you say this is not needed, which is right now ?
Symantec write this to each SQL Backup job.
You have to create one full and two incremental jobs.
Now you say this is not needed, which is right now ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
OK thanks,
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok thanks for all the input.
One last question, what is better:
1. the backup of DB and Logs via SQL Management Studio
or
2. the backup via Symantec backup Exec.
Is it wise to use both together ?
One last question, what is better:
1. the backup of DB and Logs via SQL Management Studio
or
2. the backup via Symantec backup Exec.
Is it wise to use both together ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi Scott, is this also a command ?
USE db_name
CHECKPOINT
USE db_name
CHECKPOINT
ASKER
please can you write all commands which I need in detail ?
ASKER
ok so far you helped me a lot.
I will close the ticket.
I will close the ticket.
ASKER