Viewing 15 posts - 3,646 through 3,660 (of 9,241 total)
You need to specify a suitable offline time to run the Sqlio comands,
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 7:08 pm
Mani-584606 (1/24/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 11:45 am
Perry Whittle (1/24/2014)
why are you backing up the system databases?will the disk drives\paths be the same between the machines?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 9:19 am
why are you backing up the system databases?
will the disk drives\paths be the same between the machines?
Will the new server have the same name and IP address, will the SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 9:07 am
The best practice is at the cluster level not the app, that's what i'm trying to point out. The nodes undoubtedly have access to shared storage as the OP is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 8:58 am
praneethydba (1/24/2014)
I have to migrate 15 MSSql server 2008 R2 database residing on VM to Physical machine of same version of SQL Server..
I have prepared a procedre..
1. Backup of both...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 7:46 am
Maddave (1/24/2014)
Stop the log shipping backup job.
Set the database to simple recovery.
Perform the index creation.
Set the database back to full recovery.
Take a differential...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 7:44 am
TheSQLGuru (1/23/2014)
Best practice for 2 nodes Always On is to use a File Share witness.
Mmm, that's not a BP that i've ever read in the AO documentation.
The quorum configuration...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 3:54 am
PearlJammer1 (1/23/2014)
At first I changed the registry setting 'LoginMode' from 1 to 2 (HKEY LOCAL MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.SQL2012\MSSQLServer and I still could not log on with the sa account.
yes, a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 3:24 am
Akayisi (1/24/2014)
Koen Verbeeck (1/24/2014)
ALTER ROLE (Transact-SQL)The question is: why would you want to. The user is sysadmin so he/she can already do everything.
Hi Koen, the reason why i want to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 3:18 am
you might want to find out what is causing the log to blow in the first place 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2014 at 9:01 am
well done
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2014 at 8:16 am
Joe.Spitler (1/23/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2014 at 8:03 am
the main point of confusion was that the OP was under the impression the cert was encrypted by password when in fact it wasnt, it's protected by the DMK. Had...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2014 at 7:57 am
edit the volume in windows disk management, do you see a drive letter and a volume mount point name?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2014 at 7:29 am
Viewing 15 posts - 3,646 through 3,660 (of 9,241 total)