Viewing 15 posts - 7,501 through 7,515 (of 9,244 total)
sqlbee19 (10/21/2010)
Thanks.Do I need to set Max memory and min memory if I enable lock pages in memory setting ???
The KB link posted above by Gianluca Sartori quotes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 4:22 pm
Vikash
presumably when you designed the package you ran with a connection configured to a test database. Now you have deployed the package did you change the connection to connect to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 4:03 pm
use the extended stored procedure XP_Delete_File to remove old backup files, it deletes based on the file date.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2010 at 3:45 pm
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
Viewing 15 posts - 7,501 through 7,515 (of 9,244 total)