Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andrew_morine
Starting Member
3 Posts |
 Posted - 2008-12-02 : 18:05:53
|
| Hi,I'm new to SQL.I have setup 2x Windows 2008 x64 servers with SQL 2005 x64. I've setup a new database with log shipping. It performs a transaction log backup ship and restore every 15 minutes to the secondary server and old files are removed every 3 days. The process works no problems to the secondary server.I have come across something I'm not very sure of. The primary server database file and transaction log file have a modified date of when I last performed a manual full backup (14/11/2008). The Transaction log backups are dated 30/11/2008 - 3/2/2008 (which coincides with the 3 days of removing old files). Shouldn't the Primary database file and transaction log file be updated every time the transaction log backup occurs for log shipping?It appears that I now have an out of date primary database and transaction log file.I'm not sure what to do here. Any advice would be most welcome.Regards,Andrew |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
andrew_morine
Starting Member
3 Posts |
Posted - 2008-12-02 : 20:25:42
|
Thanks Tara.  So, if I was to perform a full backup of the primary database now, it would be current and up-to-date without loss of data?Regards,Andrew |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-03 : 09:56:09
|
quote:
Originally posted by andrew_morine
Thanks Tara. So, if I was to perform a full backup of the primary database now, it would be current and up-to-date without loss of data?Regards,Andrew
Yes. |
|
|
|
andrew_morine
Starting Member
3 Posts |
Posted - 2008-12-10 : 16:40:40
|
| Thanks again Tara.Would you recommend setting up a maintenance plan to perform a full backup in conjunction with log shipping? If so, is there an easy way to do this?Regards,Andrew |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Log shipping configuration help!