Viewing 15 posts - 6,301 through 6,315 (of 9,241 total)
larrykl (10/31/2011)
I didn't realize shared storage is a requirement. We already popped for Win2K8 Ent. Edition too.
exactly why you should always research what is required before purchasing anything, even...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 4:35 am
Thank you Mohammed
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2011 at 11:31 am
ALZDBA (10/28/2011)
clustering. Is another HA. Option which has its own downsides.
and overkill if you only have a handful of databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2011 at 7:02 am
spidey73 (10/27/2011)
The database files are on the SQL server itself.
The SQL service account is a Active Directory account that got access to the database file...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2011 at 6:33 am
run NET SHARE on the passive node and check the output
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2011 at 2:14 am
can you post details of the query, table and the indexes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2011 at 2:04 am
Run DBCC UPDATEUSAGE against one of the databases and then te run CHECKDB, let us know how you get on.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2011 at 1:35 am
Ed Zann (10/26/2011)
the default database is scripted out for the login, so it must exist on the destination or the statement will error out and not create the login.
This is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2011 at 12:01 pm
yes the installer is still the same
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2011 at 10:10 am
from memory go to Control Panel > Programs > Programs & Features. Select SQL Server 2005 and click change
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2011 at 9:58 am
spidey73 (10/26/2011)
The strange thing is that from the 11 databases (including the system dbs) the same 5 always fail.
Have these databases come from a legacy\previous version of SQL Server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2011 at 8:44 am
there's a nasty bug in the sp2 installer which if i remember correctly doesnt affect the sp3 installer.
with sp2 you cant run the installer and patch only the one node....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2011 at 10:46 am
what service pack is the live instance currently at?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2011 at 10:13 am
i've already answered this in your duplicate post 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2011 at 10:12 am
when you configure log shipping the alert jobs are created for you.
Please post the full results of the following executed against your secondary instance
sp_help_log_shipping_monitor_secondary
@secondary_server = 'secondary_server',
@secondary_database = 'secondary_database'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2011 at 8:50 am
Viewing 15 posts - 6,301 through 6,315 (of 9,241 total)