L_avital (1/22/2010)

---

Hi Roy, thank you for our reply. I know why I take the backup. My plan as I think it should be, is like this: on a new server...

Another thing to consider is what is meant by local storage. Local storage can be direct attached - in that box or a SAN. The SAN can be...

And, just to make things a bit simpler...

I would be concerned about opening/closing a connection every 15 seconds. If you are using connection pooling and/or not actually closing the connection, then not much to worry about....

Gail - the concern I would have here is that the OP is looking at...

Here is one of the better scripts available for perform a smart reindex: http://sqlfool.com/tag/indexes/

Wrong - COPY_ONLY is not available when using the GUI in SSMS 2005, however - you can still...

Dugi (1/14/2010)

---

I think that with SSMS you cannot do it as schedule!

You should create PowerShell script that will stop the SQL Server services, copy files from folder to other folder,...

You want to lookup Ranking Functions in Books Online and probably use ROW_NUMBER() to get the results you are looking for.

And, do not upgrade your existing instance or tools. They will work side-by-side with no problems at all. If you have to support any 2005 instances at all...

Lynn Pettis (1/14/2010)

---

Now I'll plug HyperBac. I like HyperBac because it works in the background, no changes are needed to existing processes. We still use the T-SQL native...

You cannot use a 32-bit driver from a linked server. The linked server process is running in x64 - which means you have to use x64 drivers.

No - changing from FULL to BULK-LOGGED and back again does not break the log chain. Changing to/from SIMPLE breaks the log chain.

See the article I link to in...

I don't know of any way to do what you want by directly calling the procedure. You can create a report in SSRS that will render on multiple sheets,...

That is normal behavior - and yes, the data you are accessing is not in the data buffer and has to be loaded. Once loaded, your queries will get...