I have understood the importance of transaction logs but still unclear on a few things:
I've taken back-up of a T-log using this statement:
BACKUP LOG myDB TO DISK = 'I:\Log_Backup\myDB.TRN' GO
Then i used the following statment to monitor the space used:
DBCC SQLPERF(LOGSPACE);
GO
Log spaced used which was previously large went down to 0.859 %
Now on the issue of backing up i have two questions:
Our TSM guy is backing up the folders:
I:/Database
andI:/Logs
thrice a day. I:/Database is the folder with all the MDF-files and I:/Logs is the folder with all the LDF-files. Shoud he instead be backing upI:/Log_Backup/
andI:/Logs
? Or should he be backing up only I:/Logs where all the actual logs reside.In case of a disaster when i need to retore a DB, should i use the last back-up from I:/Log_Backup/ or from I:/Logs