The OP posted that it is SQL Server 2005 Standard, the feature you...

How large is the table in terms of size? Just wanted to compare to what I have at my end..

Had no locking issues..

Though the backup was slower (as expected)...

I had just initiated the same steps on one of my 2005 instances at home. seems to be going ok. Will update once again..

Have you seen...

Read this blog I wrote.. list-of-all-data-and-log-files-of-a-sql-instance[/url]

Modify the column names to fit your need.

george sibbald (12/14/2011)

---

Bru Medishetty (12/14/2011)

---

George, will it not fail as the physical database files exist and the rerun job...

George, will it not fail as the physical database files exist and the rerun job cannot overwrite those files..

Hi Kevin,

What is the size of the database? The reason for asking this is... to suggest you to make sure you have the required disk space to store the FULL...

As per SQL Server Database best practices, you should be having separate drives for DATA files, LOG files and TempDB (so at least 3 drives).

Regarding T-Log file size, it depends...

To answer part of your question, SQL DBA may or may not be part of AD Admin group. I am not a part of AD Admin group, but I am...

Stefan Krzywicki (12/14/2011)

---

Thanks everyone, these responses plus things I'm finding on-line, like articles by Brent Ozar are getting me to the point where I can at least ask intelligent questions...

I agree to what was already said by the Craig.

About leaving the Log files on the Largest drive on the Server (keeping it local), is that drive fault tolerant?

The...

Ok..

Let me clarify this. What they see (SQL Server using 5GB consistently) is normal. SQL Server starts with a low Memory usage and as it needs, grabs more and...

If you have no databases on the current SQL Server 2008 instance, then go ahead and uninstall it (use Programs and features and uninstall SQL 2008) and install SQL Server...