Viewing 15 posts - 5,491 through 5,505 (of 9,241 total)
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
Jeffrey
the user requires the clear text password for the SQL server account so sp_help_revlogin wont be helpful here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 11:13 am
Abhilash T (6/3/2012)
yes Right,Bu I couldn't change it. Bcz its live and lot of developments done with this.
hmm, seems a bit daft to me to be honest. What if someone...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 11:11 am
Abhilash T (6/3/2012)
Hi All,I have a table with lots columns(all columns not included here).
ISSUNDAY BIT,
ISMONDAY BIT,
ISTUESDAY BIT,
ISWEDNESDAY BIT,
ISTHURSDAY BIT,
ISFRIDAY BIT,
ISSATURDAY BIT)
Why not just have one column for the weekdays...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 4:30 am
Viewing 15 posts - 5,491 through 5,505 (of 9,241 total)