Viewing 15 posts - 3,646 through 3,660 (of 9,244 total)
bugg (1/26/2014)
To allow the current log to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2014 at 3:04 pm
Firstly, DONT TYPE IN CAPS, its extremely rude 😉
To shrink the log file the first step you have accomplished, setting recovery to simple. Next issue the following
DBCC SHRINKFILE (Logfilename,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2014 at 2:39 am
IT researcher (1/22/2014)
1)I have a database which grows about 300 MB every...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 7:15 pm
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
Viewing 15 posts - 3,646 through 3,660 (of 9,244 total)