Viewing 15 posts - 3,811 through 3,825 (of 4,745 total)
As was alluded to earlier with windows 2008 you can set up multi-site clustering using a vLAN. setting up the cluster may be different but its transparent to SQL and...
---------------------------------------------------------------------
March 20, 2009 at 11:27 am
I have tested copying back a saved away latest copy of the resources database to bring your instance up to date with patches and it works. I had some fun...
---------------------------------------------------------------------
March 20, 2009 at 11:14 am
A lot of the hardware that people are talking about which allows them to be more productive is dependant on one 'invention', the internet, and in particular broadband access allowing...
---------------------------------------------------------------------
March 20, 2009 at 4:03 am
SUBRAHMANYA HEDGE (3/19/2009)
You can also use SSIS for transferring Jobs and Logins from your primary server to secondary server.
be warned - if you use the SSIS transfer logins task it...
---------------------------------------------------------------------
March 19, 2009 at 4:09 am
seems I should have referred to 'undo' rather than redo. See I said Oracle was confusing.
If this area did not go into tempdb it would have to go into each...
---------------------------------------------------------------------
March 18, 2009 at 9:46 am
one of the great things about SQL server is the simplicity of the database architecture, particularly as compared to Oracle, do we want to go down the road of having...
---------------------------------------------------------------------
March 18, 2009 at 7:53 am
for how to handle logins google 'sp_help_revlogin'
---------------------------------------------------------------------
March 18, 2009 at 3:53 am
NO! I'm spartacus!
---------------------------------------------------------------------
March 17, 2009 at 4:41 pm
ensure the latest tranlog backup you managed to copy over to the secondary server is restored to the secondary database. Easiest way is to see what the latest file is...
---------------------------------------------------------------------
March 17, 2009 at 2:44 pm
Tebeho, forum etiquette is you should start your own thread when you have a somewhat unrelated question.
However, if you have not added your user databases yet or gone live you...
---------------------------------------------------------------------
March 17, 2009 at 9:04 am
Mohit (3/16/2009)
george sibbald (3/16/2009)
thats rather a lot for mirroring. Doable with log shipping though.
I have over 30-40 databases running on my SQL Server 2005 server with no issues; have you...
---------------------------------------------------------------------
March 16, 2009 at 3:41 pm
about the elapsed time as I see.It is a big install.
Have you copied the software local to your machine or installing over the network? Are you installing every single feature?...
---------------------------------------------------------------------
March 16, 2009 at 3:08 pm
thats rather a lot for mirroring. Doable with log shipping though.
Both mirroring and log shipping have the advantage of duplicating the disk storage, improving resilience there.
If you must persist with...
---------------------------------------------------------------------
March 16, 2009 at 2:57 pm
how many databases, mirroring could be seen as a poor mans cluster (no insult intended!)
---------------------------------------------------------------------
March 16, 2009 at 10:35 am
EdVassie (3/16/2009)
Each server...
---------------------------------------------------------------------
March 16, 2009 at 7:23 am
Viewing 15 posts - 3,811 through 3,825 (of 4,745 total)