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...
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...
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.
October 21, 2010 at 3:45 pm
correct, you may use a SQLExpress instance for the witness server!
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...
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!
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
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...
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)
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!
October 21, 2010 at 5:11 am
Ed Vassie already has this available at this link
October 21, 2010 at 5:07 am
you could use the web stress tool from MS
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...
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...
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...
October 20, 2010 at 3:06 pm
Viewing 15 posts - 7,501 through 7,515 (of 9,244 total)