Solved

sql 2005 transaction log backups

Posted on 2011-09-12
6
283 Views
Last Modified: 2012-05-12
hi all

i am trying to set up a transaction log back up against one db (its in full recovery mode), i create the backup as the picture illustrates and select the db, but each time i save and close out it loses the database selection !

i cant see what i could be missing?

also if anyone has any important steps i should be following when backing up the log files - please feel free to advise! eg i have read that there is an option to ignore transactions once they are backed up - but cant see it?

cheers

mal
bkup.JPG
0
Comment
Question by:malraff
  • 3
  • 2
6 Comments
 
LVL 8

Expert Comment

by:dba2dba
ID: 36523270
Did you have the DB Setup to FULL Recovery mode?

Before taking a transaction log backup, you should

1) Change the recovery model to FULL

--ALTER DATABASE DATABASE_NAME SET RECOVERY FULL
--or using GUI . Database Properties - Options - Change it to FULL

2) Take a Full Backup

You have to do this in order to be able to setup transaction log backups.

Thanks,
0
 

Author Comment

by:malraff
ID: 36523289
did you read my question :)
0
 

Accepted Solution

by:
malraff earned 0 total points
ID: 36523563
must be a bug in sql !
as despite not showing the database that i have selected the plan is still running and backing up my logs!??

even if i select view T sql from the job it shows me nothing!
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 8

Expert Comment

by:dba2dba
ID: 36523787
Sorry, I did not read the question properly. You can try applying the latest SP/Hotfix.

THanks,
0
 
LVL 1

Expert Comment

by:dervishi
ID: 36534454
Tryto make trn backup using sql script

Backup Log "database_name" to "filebackup.trn.
0
 

Author Closing Comment

by:malraff
ID: 36572245
sql server bug
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
back end of ssas cube views or tables? 2 29
MS SQL Backup 24 72
Table create permissions on SQL Server 2005 9 15
SQL Query 2 0
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now