Viewing 15 posts - 196 through 210 (of 1,790 total)
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 19, 2011 at 8:46 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 19, 2011 at 8:43 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 18, 2011 at 3:20 pm
Grant Fritchey (4/1/2011)
Fixed it. Sorry about that.
No worries here. That is a great post to cover the topic though. Thanks for fixing it. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 1, 2011 at 9:13 am
Grant Fritchey (4/1/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 1, 2011 at 8:26 am
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
If it is the post I am...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 31, 2011 at 7:53 am
srdjan.katic (3/28/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 28, 2011 at 8:14 am
srdjan.katic (3/28/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 28, 2011 at 7:41 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 25, 2011 at 2:48 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 25, 2011 at 10:16 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 23, 2011 at 2:12 pm
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,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 23, 2011 at 11:12 am
open - typo. 🙂
How are you opening the table?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 23, 2011 at 10:47 am
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,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 23, 2011 at 10:32 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 22, 2011 at 3:02 pm
Viewing 15 posts - 196 through 210 (of 1,790 total)