Viewing 15 posts - 7,501 through 7,515 (of 9,241 total)
correct, you may use a SQLExpress instance for the witness server!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 11:03 am
Just a word of warning about Diff backups. They incorporate all the changes since the last Full, they append each time and will get bigger and bigger until the next...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 8:12 am
for the "FailoverPartner=" clause to work you must be using ADO.NET or SQL Native client for your database connection!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 7:56 am
snivas (10/21/2010)
2.Can I start Installation(Side by Side) from Passive node ?
active or passive, you may want to read the MS article regarding installing SQL server 2008 alongside 2000
snivas
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 7:31 am
Bh 58161
Forgetting endpoints, authentication and mirroring modes, database mirroring is based upon a restore of the principal database. You really need to research and understand this more before going any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 7:13 am
bh 58161 (10/21/2010)
I know restoring it isn't how mirroring works.
Actually that's exactly how mirroring a database starts!
bh 58161 (10/21/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 6:32 am
snivas (10/21/2010)
SQL Server 2008 R2 side by side installation in Cluster(Active/passive on Windows 2003 SP2).
Are you sure you really want to do this?
Windows 2008 would be a better option!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 5:11 am
Ed Vassie already has this available at this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 5:07 am
you could use the web stress tool from MS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 5:05 am
bh 58161 (10/21/2010)
I am new to this forum and pretty new to SQL Server 2008. I have been asked to look into setting up a high availability database.
What I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 4:54 am
jeff.mason (10/20/2010)
I thought that we were supposed to stop using the xps as they were going to be deprecated....?
Well it's still there in SQL Server 2008 and 2008 R2, can't...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2010 at 4:19 pm
Michael Valentine Jones (10/20/2010)
realise that you are probably vastly increasing the cost and complexity of the system, and decide if it is really worth the cost.
It's surprising how many organisations...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2010 at 3:06 pm
Don't worry, if there's an angle to exploit MS will be there on top of the game 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2010 at 3:01 pm
What's wrong with the extended stored procedure that MS supply??
--for first parameter (0) = FileBackup and (1) = FileReport
-- 1 at the end means include first level subfolders in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2010 at 2:34 pm
going to need a lot more information hear my friend!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2010 at 2:18 pm
Viewing 15 posts - 7,501 through 7,515 (of 9,241 total)