My problem is that I use T-SQL but there are too many Log backup files that it seems that the GUI is by far the fastest way to resore.

I'm concerned...

Ed Wagner (1/28/2016)

---

It looks like you have the clicks right, but the best way is to use T-SQL.

If you must use the GUI, be sure to not overwrite the production...

The following URL looks like what I want to do:

http://sqlblog.com/blogs/merrill_aldrich/archive/2013/03/15/ssms-2012-restore-gui-gotcha.aspx

Any clarifications would be greatly appreciated.

I found this:

Use the Management Studio in the following fashion to learn what you need:

Choose your database, right-click and select Tasks / Restore / Database.

On the Restore...

I'm going through these articles.

I also to a quick look at the video.

Thanks.

Yes this video is moor clear and detailed. I will keep it as a reference.

I'm looking specifically at troubleshooting...

Actually the part that I have trouble following stats at 2:500 at the following URL:

https://www.youtube.com/watch?v=MxXVZ2pTsLs

EXEC sp_SpaceUsed tblCall

namerows reserved Data index_size unused

tblCall1296410 19254232 KB...

There are only 1,296,391 records but the table is wide.

I recommended that we did not partition the table. There is too much risk among other things but someone thinks that...

The records in the call table are updated Regularly.

Thanks.

Hugo Kornelis (1/19/2016)

---

If you want to partition by year, then you will first have to make sure that the date column is the leading column in the clustered index. You...

Jeff Moden (1/19/2016)

---

Possibly, a shedload. What have you used as the...

Jeff Moden (1/19/2016)

---

Possibly, a shedload. What have you used as the...

The ID Column is the Primary Key.

I archive some records already.

To what extent would that complicate things?

The following years have not been archived:

The following years have been archived:

2008R2 does not have the data structure that I need.

It does not have the DimTime Dimension.