Viewing 15 posts - 5,506 through 5,520 (of 9,241 total)
Develop locally and use package variables, you can then update the connections when deploying to live
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 4:21 am
I had a discussion with another user regarding AO and fail over clusters, you can follow the topic at this link[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 4:17 am
Bobby Glover (6/3/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 4:07 am
dan-572483 (6/2/2012)
Is this because SSMS 2008 can connect to an R2 instance?
No you should be able to connect but certain features won't work when trying to use them possibly.
dan-572483...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 4:02 am
Bobby Glover (6/3/2012)
Probably a easy one,I've inherited a new SQL 2008 Enterprise environment which uses encrypted databases.
I don't have the passwords for the certificate.
Your statement implies that the certificate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 3:25 am
If the web.config is encrypted or, if it's a windows form app, it encrypts the details in a registry key then it should be fairly safe.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 2, 2012 at 1:25 pm
Shark Energy (6/1/2012)
Cache could be an issue. Previously this server had its...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 2, 2012 at 1:53 am
Remember that your offset is ultimately dependent upon your RAID stripe size, you probably shouldn't just accept the windows default. There are a whole bunch of calculations to make including...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 2, 2012 at 1:51 am
opc.three (6/1/2012)
IIRC Server 2008 uses an offset of 1024KB as a default when provisioning a new disk
Yes it does it's a sort of one size fits all, default configuration.
opc.three (6/1/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 6:47 pm
Shark Energy (6/1/2012)
Good questions - I have that all written down for the old server but not for the new one.
Investigate thoroughly and compare them to see the differences.
Shark Energy...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 6:20 pm
Why can't you just change the password and update the app connection?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 6:06 pm
number of disks?
cache size?
RAID stripe size?
Storage paths?
There are so many factors that can have an effect.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 2:37 pm
Before you just go detaching databases you may want to record their physical and logical filenames. Do this using
select 'Logical file ''' + name + ''' from database ' +...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 2:11 pm
Don't know offhand, but just open up the restore window and try to locate the new drive, if it doesn't like it it will soon let you know.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 4:50 am
srivathsani-296624 (5/31/2012)
We are not sure if the node is still a part of the cluster
Windows 2003 or Windows 2008?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2012 at 4:26 pm
Viewing 15 posts - 5,506 through 5,520 (of 9,241 total)