Thank you for your sound advice on doing some back ground reading on SQL Server principals. I shall take look at the books online documentation.

Can you give some examples how to create additional file on a C: drive where I have free disk space available?

I have looked in Task Manager to see if any...

The log file (XXX.ldf) located on the C: drive.

The main database file(XXXX.mdf) located on the D: drive.

So they are on separate disks.

By the I have found a large...

Hello Brandie,

Thank you for your kind advice.

So there is no way to move a table and its data from one physical disk location to different physical disk location without some...

Hi ALZDBA,

Thank you for your reponse. The link you provided requires the database to be offilne.

What I am looking for is a way to move or copy all objects...