Viewing 13 posts - 151 through 163 (of 163 total)
P Jones (1/30/2009)
Then repeat...
January 31, 2009 at 5:16 am
Only drawback seems to be an increased shutdown time (which equals increased server reboot time).
January 31, 2009 at 5:08 am
As Greg said, in an A-P cluster, the SQL Server service does not run on the P node unless the cluster group is failed over.
The only way you could replicate...
January 31, 2009 at 4:57 am
I think the real question is, how much can you afford to spend?
The entry level DR features of SQL Server like log-shipping work ok, then database-mirroring is worth looking at.
If...
January 31, 2009 at 4:48 am
Should be fairly easy using Integration Services.
The simplest way to use this ETL tool would be:-
1) In Management Studio click on the database from which you wish to export data.
2)...
January 29, 2009 at 10:52 am
Idera's "SQL Admin Toolset" comes with a tool called "Multi Query" that allows you to run the same SQL query against any number of named instances.
Come to think of it,...
January 27, 2009 at 7:10 am
That's a really good link.
I can see the cut-and-pasteability of that being very useful if faced with the task of writing a business proposal for SQL Server consolidation.
January 26, 2009 at 9:39 am
Sankar Reddy (1/25/2009)
On a side note, dropping a snapshot actually flushes the entire procedure cache in SQL Server 2005.
I didn't know that, thanks Sankar, I learn something new every day!
January 26, 2009 at 3:49 am
Forgive me if I've misunderstood the question.
I don't see how the vew could be added to the snapshot, since snapshots are read-only copies of a database at a certain point...
January 25, 2009 at 1:31 pm
I don't think that you can do this.
I think that SQL Server will always default to the file locations recorded in the backup - which will be the file locations...
January 25, 2009 at 1:10 pm
SQL Server consolidation simply means taking databases, services, jobs etc. housed on a proliferation of SQL Servers and migrating them to one or more large centralised SQL Servers.
The objective of...
January 25, 2009 at 12:44 pm
I use Idera SQL Diagnostic Manager and I find it very good.
It's easy to install and configure, simple to use, and has a lot of really well thought out features.
You...
January 25, 2009 at 12:36 pm
What a great article, following it through I was able to get SSL working on my RS 2005 installation first time!
Shame on Microsoft for making it so arcane and obscure to...
December 1, 2005 at 5:27 am
Viewing 13 posts - 151 through 163 (of 163 total)