Marcia Q (3/2/2010)

---

Aeterna - Thanks!

klnsuddu - Take a look at Jeffery's post. Bulk_logged recovery mode doesn't matter with indexing.

To answer your question though - According to BOL...

You need to talk to the administrator of that system and find out where you can put your backup file so it will be accessible to that system. You...

Is there a reason you cannot perform a backup/restore? If that cannot be done, download the trial edition of SQL Compare and SQL Data Compare from Redgate. Use...

InvoluntaryDBA (2/24/2010)

---

I guess I missed some detail in my post. This table is a history table we created to track changes to data. So data never gets updated, only inserted...

I find that this is one of the most mis-understood concepts in SQL Server. The belief is that because you have an auto-incrementing key, you will never have fragmentation...

In order for you to be able to use the WITH MOVE option, you are going to have to know the logical names of all of the files for that...

I would recommend using Powershell and SQLCMD - with powershell you can parse a directory for the latest file(s) by date, and build a string to execute the restore that...

When you make that change in the GUI - it performs an index rebuild with the fillfactor defined as 75%. The only way to change the fillfactor on an...

sunil.aggi (2/24/2010)

---

Thank you for your reply Jeffrey.

However my question is with regards to SQL 2005.

My .ldf file size is growing and is crossing its threadshold limits. Now I need to...

All that command does is sets the default fill factor that will be used when indexes are created and the fillfactor is not specified.

When indexes are rebuilt - the fillfactor...

Are you sure your transaction log backups are running? If so, then most likely you have a nightly/weekly operation to rebuild indexes that is expanding the log file. ...

I am not sure where you got your information - but it is not correct.

First, that backup command is deprecated and no longer works in SQL Server 2008....

Is this x64 system?

If so, have you set max memory?

How much memory is available to the system?

If you have 24GB of memory available - you should be setting the max...

I quoted your statement, and I questioned your statement about shrinking databases on a routine basis. If you do not shrink your databases on a routine basis - then...

jpSQLDude (2/22/2010)

---

Also, as I see it, I have three options for backups:

1. Come up with TWO systems, one for versions 7 and 2000, and a different one for 2005 and...