Solved

sql 2005 transaction log backups

Posted on 2011-09-12
6
286 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSIS with VPN COnnection 2 76
Run SQL Server Proc from Access 11 31
Sql Server group by 10 27
SQL view 2 27
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

770 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