Viewing 15 posts - 4,456 through 4,470 (of 9,241 total)
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
In failover cluster manager, expand the virtual network name resource and the virtual IP resource will be there.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2012 at 2:46 pm
mike 57299 (12/10/2012)
Yes, the data in a writable state is a must. That is why mirroring and log shipping won't work.Mike
It wasn't stated hence my question, now that we...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2012 at 11:17 am
sqlfriends (12/10/2012)
Perry Whittle (12/5/2012)
ALTER DATABASE mydb...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2012 at 11:05 am
Viewing 15 posts - 4,456 through 4,470 (of 9,241 total)