Viewing 15 posts - 4,411 through 4,425 (of 9,241 total)
b.ammad (1/7/2013)
I have a 2 node Active/Passive cluster mounted in Windows Server 2008 R2. Currently on the active node there's a SQL Server DB Engine instance running. SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2013 at 1:30 am
I can't say I've seen that before, are you sure you modified the xml file the same on all nodes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2013 at 8:49 am
iamsam.sandeep (1/6/2013)
HI.Just wanted to know if there is any difference betwen Sql patching in 2005 and 2008 Cluster evn
Not just the patching but the installation of the product...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2013 at 3:53 am
balasach82 (1/5/2013)
[Taking backup of db and restoring the same db and changing the file location while restoring]
Example:
Database: Inventory
Backup Inventory
Restore Inventory (replace existing Inventory...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 1:45 pm
most times a differential backup will do the job 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 11:26 am
Contrary to popular belief you do not need to stop SQL Server, there, that's that over with 😉
To move the database files perform the following;
get the logical filename and current...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 11:24 am
you need to change the node IPs first so that the cluster networks are updated with the new IP\mask. Once this is done change the virtual IP for any client...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 11:08 am
Are you just changing IP addresses or are you moving domains too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 5:42 am
Have you checked the job schedules?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 5:40 am
did you run the query above?????
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 5:26 am
SQL server will take care of itself.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 5:25 am
KcV (1/4/2013)
I have just shifted my database of sql 2000 to sql 2008 64 bit after running Upgrade adviser.
then i run DBCC DBREINDEX in all tables.
After that when i checked...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 5:07 am
OS error 2 means the specified file could not be found, was it purged or deleted maybe?
What are your retention periods on the primary and secondary?
To repair the LS scenario...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 4:52 am
If you have role separation in the organisation then the OS and the cluster should be managed by the Windows server team. SQL Server obviously manmaged by the DBAs.
I have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 4:47 am
Follow the original link, it describes exactly what you need to do!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2013 at 10:10 am
Viewing 15 posts - 4,411 through 4,425 (of 9,241 total)