Sure you can do it. You could use "restore filelistonly" to get the file information from the backup file and then build your restore dynamically from that and the other...

Sure. You would have to query the database that is published and look in the sysarticles table. You could pull all the pertinent information into variables from that table and...

You should be ok. How long do you expect the move to take? I wouldn't disable anything but the distribution agent, not logreader or distribution clean-up. If it was going...

No worries here. That is a great post to cover the topic though. Thanks for fixing it. 🙂

Grant Fritchey (4/1/2011)

---

On a guess, the optimizer timed out trying to unpack the views and the "best" plan at the time of the timeout was missing the predicate because the...

If it is the post I am...

srdjan.katic (3/28/2011)

---

There is one potential issue since vmware will be hosting virtual Sql 2008 R2 cluster. For SQL cluster vmware has to deploy raw disk format instead of vmdk disk...

srdjan.katic (3/28/2011)

---

We are waiting for NetApp that have snapshot manager for sql but i am not sure it will do all the work. I was thinking about sql transactional replication,...

This site will give you all the details that you need.

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

My guess is that the version you are referencing is for one particular component within MDAC, maybe the dll...

Every hour? How big is the database?

Honestly I would look at transactional replication unless there is just a TON of data loading going on in the main database. That...

Can you also start your query and then running the following in another connection;

select session_id, blocking_session_id, wait_type, wait_resource, wait_time, last_wait_type from sys.dm_exec_requests where session_id =

You will have to...

So you are doing a "select from yourtable" and it is slow in returning the data? Are you watching for any blocking to see if that is causing problems. Also,...

open - typo. 🙂

How are you opening the table?

Some of the SAN vendors will allow the option whether they want to write the snapshot backups to the history tables. Kind of them.... Others do it as a default,...

Yeah - I'm about 6 hours away (not 24) driving but may still try to get on that list and start to plan for the trip.

Thanks for sharing it...