Viewing 11 posts - 421 through 431 (of 431 total)
Larry Page(Ehs_Akb) (4/11/2012)
i am using sql server2008.and so you mean when the data is restoring we can use that ?
Larry, Whichs edition are you using?.....if it's enterprise then you are...
April 13, 2012 at 12:34 pm
Henrico Bekker (4/13/2012)
Sys db's on own disk, but have tempdb on its own drive.
user db's on own disk.
split mdf and ldf's...
April 13, 2012 at 11:06 am
Larry Page(Ehs_Akb) (4/11/2012)
so when the principal server is failed, the mirroring server is coming .so is the principal sync with mirroring server after failing?or we should sync that?
Well, it...
April 11, 2012 at 2:20 pm
SQLKnowItAll (4/11/2012)
April 11, 2012 at 1:27 pm
I beleive in 2005, 2008 and 2008R2, you can read from mirror DB by doing a snapshot of mirror. Your thoughts.
April 11, 2012 at 12:45 pm
No, Mirroring is a DR solution. I believe you cannot use Mirroring for load balancing. If something goes wrong with Principle Server, you have the Mirror DB to...
April 11, 2012 at 12:37 pm
Yes, maintenance plan would work.....there are some nice videos in youtube which shows how to create it.
April 11, 2012 at 11:59 am
Well, index helps to read data faster. There are two types of indexes, Clustered and Non-Clustered Indexes.
Clustered Index - provide the actual data page at the leaf level of...
April 11, 2012 at 11:57 am
1. What is mirroring and how would you configure mirroring?
• Database mirroring is a primarily software solution for increasing database availability. Mirroring is one of the disaster recovery solution and this feature...
April 11, 2012 at 11:48 am
My apologies, will do my homework next time before asking for help.
Take Care.
April 10, 2012 at 10:49 am
Viewing 11 posts - 421 through 431 (of 431 total)