Viewing 15 posts - 4,456 through 4,470 (of 9,244 total)
RVO (12/13/2012)
We are planning to install SQL Server 2012 Enterprise on clusterin two weeks.
Anybody done this?
Yes, I have
RVO (12/13/2012)
If yes, maybe any heads-up, any tips?
The installer is pretty much...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2012 at 7:46 am
DBCC CHECKDB would be one of the most common if you're smart 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2012 at 6:37 am
Believe me, there's nothing difficult about the script i gave you above
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2012 at 5:42 am
Try refreshing the connections
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2012 at 3:34 am
I agree with Robert, avoid re mapping unless necessary. Create the login with the correct SID, this script is also useful for generating CREATE LOGIN ... statements from a source...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2012 at 2:06 am
Yes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2012 at 2:35 pm
Which storage driver are you using
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2012 at 2:13 pm
Hmm ghetto default for Windows 2012 is to set up the disk as GPT when laying the partition down, I'll need to dig into this a little more when I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2012 at 11:13 am
mike 57299 (12/11/2012)
Log backups are 30 min everyday between 8am and 6pm. Once the t-log has been restored - it will be deleted.
I want to write or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2012 at 8:13 am
have you run a log backup since removing the extra log file?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2012 at 6:41 am
It's deprecated but still usable in SQL Server 2008 R2 and it's a one liner. As follows
USE [real]
GO
EXEC sys.sp_change_users_login 'Auto_Fix', 'appp', NULL, 'somepassword'
GO
Then just use
EXEC sp_addsrvrolemember 'appp', 'bulkadmin'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2012 at 5:30 am
shohelr2003 (12/11/2012)
Is there any security issue? Please let me know.
Yes, hence why you should use certificates!! See more on NTLM and passthrough authentication at this link.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2012 at 4:58 am
mike 57299 (12/10/2012)
That is why I want to have a script to restore it each night.
your script will need to restore and recover the following each night
any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2012 at 11:12 pm
see this link for configuring mirroring using certificates.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2012 at 3:01 pm
vijayjain347 (12/10/2012)
Sql server 2012(Standard edition) and windows server 2012(Standard edition) will support AlwaysOn High Availability ???
You will need SQL server 2012 Enterprise edition.
vijayjain347 (12/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2012 at 2:55 pm
Viewing 15 posts - 4,456 through 4,470 (of 9,244 total)