You can build the command for the LOG restore by querying the MSDB..BACKUPFILE table. Something like this:

Removed because the code wasn't correct

See post below for correct code

You can adjust and/or...

chris.miller1 (6/26/2013)

---

Here goes my first post in here...I have recently slipped into the "Accidental DBA" role and my first task is ensuring that the SQL Server is backed up properly...

The code you posted in the first post does NOT contain a cursor. It does...

Hi Sean,

That's an interesting link. I've never thought of using the "0" in the DATEDIFF function, but it's an nice approach and consistent for the different dateparts (and therefor more...

The database will not come ONLINE because there is a mismatch between the location of the mdf-file stored in the system database and the physical location of the file on...

The "state 10" could also refer to problems with the domain controller. The domain controller could be under stress or it could (temporarily) not be reached due to network issues.

Are...

As from Aaron Bertrands blog http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx:

The first error in your post (State 38:)

The database specified in the connection string, or selected in the Options > Connection Properties tab of the...

A NULL value is not allowed in the TOP function, hence the error. Change the number 2000 in the first script to a high number equal to or higher than...

SQLCrazyCertified (6/26/2013)2013-06-26 15:21:14.642 Agent message code 20052. The process could not access database ‘DatabaseName’ on server 'ServerName'.

2013-06-26 15:21:14.642 Category:NULL

Source: Microsoft SQL Native Client

Number: 4060

Message: Cannot open database "DatabaseName"...

Looks like the original poster has made a double post, see http://www.sqlservercentral.com/Forums/Topic1468474-384-1.aspx

Restore the last full and differential backup from primary on secundary and leave the database in NORECOVERY or STANDBY. Restore each log backup on secundary after this is created on...

Create a reference or tally table that holds all the dates of the period you need (i.e. 365 rows per year). Select the desired date range from this reference table...

Are there things changed on your instance (databases removed, recovery modes changed, etc.)?What are the steps and actions you've defined in your maintenance plan? Do you run the maintenance plan...

Take a look at the two links below. It is a bit of reading, but explains and solves your issue:

Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]

Creating a comma-separated...

xmanletoy (6/27/2013)

---

if i use union all the result like this

Msg 205, Level 16, State 1, Line 1

All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal...