Viewing 15 posts - 5,491 through 5,505 (of 9,244 total)
Chris Golla (6/6/2012)
but you can restore your 2005 msdb onto your 2008 sql server overtop the one currently there.
do not do this!
the msdb holds information relative to the sql server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 12:25 pm
Nicholas Cain (6/6/2012)
Standard edition limits you to a failover pair of nodes (versus up to 16 with Enterprise Edition) and it's not a "hot standby" situation.
Note, this does not affect...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 11:38 am
charipg (6/6/2012)
is there any problem if i stop?
it's hosed already so it won't make an ounce of difference 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 11:35 am
THE-FHA (6/6/2012)
i am trying to change multiple database to full recovery mode so that i can shrink them.
They'll likely only grow again, are you aware of the ramifications of this?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 8:24 am
How many network cards are installed and what configuration?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 8:21 am
SQLSACT (6/6/2012)
Perry Whittle (6/6/2012)
run your cluster verification and ensure there are no errors
Hi Perry
I ran the Verification and there are no errors reported
There is one warning for "Validate Network Communication"...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 7:31 am
charipg (6/6/2012)
"SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 7:09 am
run your cluster verification and ensure there are no errors
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 7:07 am
SQL Server has a TABLEDIFF.exe that you may use to compare objects, check BOL for more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 7:02 am
zsafakhah (6/6/2012)
I Created a Backup from Databases on Sql2000 and Restore in sqlserver2008 r2.
but i worry about which not granteed in sqlserver2008 r2?
how can i find list of which...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 6:57 am
What is it you are trying to achieve, please post a new thread detailing your issues.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 5, 2012 at 4:42 am
GilaMonster (6/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 4, 2012 at 2:12 pm
GilaMonster (6/3/2012)
That might be perfectly valid.
Personally I can't see any validity.
GilaMonster (6/3/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 4, 2012 at 1:10 pm
nitinuniyal (6/3/2012)
The problem is now how do i move forward to split the 1.5TB across six different drives.
Perry Whittle (6/3/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 11:56 pm
Jeffrey Williams 3188 (6/3/2012)
As for how to do it - you would create the additional files on the LUNs at the correct size and use DBCC SHRINKFILE(original file, EMPTYFILE).
Problem is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 3:45 pm
Viewing 15 posts - 5,491 through 5,505 (of 9,244 total)