Do you have any...

What is the recovery model of the databases?

Definitely not a Best Practice, but you can add a usb or sata drive and backup to that.

You're welcome.

Here are a few resources that would be of benefit to you in trying to learn about indexes

http://www.sqlservercentral.com/stairway/72399/

And

http://www.sqlservercentral.com/articles/Indexing/68439/

Other considerations besides just moving the files (code should be fine that you provided)

Consider the size of the files

Consider more files than just the default 1 data file

Consider the growth...

Jeff Moden (4/19/2013)

---

I love some of those questions. One of my favorites is...

9. I’m a manager, and you’re my Senior DBA. Explain to me why...

Let's start with this article. I am not sure the figure correlates to bytes or bits for that matter.

http://msdn.microsoft.com/en-us/library/ms176029.aspx

David.Poole (4/19/2013)

---

...

I'm going to say something contraversial here. You can do cold hard financial logical analysis of cost vs benefits and put forward a recommendation but if your business...

Obviously truncate...

How much free space is in tempdb data files?

How much free space in in the tempdb log file?

How does the tempdb log look?

Is it set to autogrow as well?

Sean Lange (4/19/2013)

---

That is a might big topic. I would not rely too heavily on DTA or the missing indexes views. In fact, I would probably not even look at...

Thanks Hugo. Good question.

It is one thing to ask for questions. It is an entirely different thing to ask for the answers to those questions.

Getting an idea of questions to be asked...

:crying:

Ouch