sounds like you are missing a log backup. Check the databases backup history from the backupset table in msdb on the primary. If there are missing log backups and you...

log files are written to sequentially, therefore there is only a need for 1 log file, no matter how many data files.

there is no performance gain to multiple log files.

full backups do not truncate the log, therefore you can restore T3 with or without F2.

thats why log shipping is able to work, you can restore tranlog backups through full...

I'll leave the quibbles on details to others but all I can say is of all the sites of this type I have looked at the overall look and feel...

j2cagle (8/3/2013)

---

You hit the nail on the head. I ended up taking the full backup of the live DB (that occurred last night), restoring it to the report server DB,...

how did you shrink the log, what commands did you issue?

Are you saying log shipping is now broken due to missing lsns?

If so and you have not issued a full...

FWIW there really is no point in separating out the master database data and log files like this.

the files with 1 in the name are created during the installation process, as part of the installation is just to copy the new version of the resource database files...

if all the DTS package does is load data from a flat file personally I would rewrite in BCP as it will likely load faster and be simpler, and fits...

EdVassie (7/30/2013)

---

Once upon a time this policy did not exist. Then it got created.

You need another company policy that says...

the syntax you want to change the log file location is -

alter database dbname MODIFY FILE ( NAME = logical_file_name, FILENAME = ' new_path/os_file_name ' )

so

stop app

backup database

run...

do you have a backup of the database? If so restore it using the with move option for the secondary file.

as its only a maintenance plan have you tried just deleting\recreating it?

why are you moving the log files for the system databases, except perhaps for TempDB there is nothing to be gained by doing that, and a lot of potential heartache...

yes, no