you can repair the issue using this script (this script is not mine)
Use [master]
EXEC sp_resetstatus RecoveryPendingModeDB
ALTER DATABASE RecoveryPendingModeDB SET EMERGENCY DBCC checkdb('RecoveryPendingModeDB')
ALTER DATABASE RecoveryPendingModeDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB('RecoveryPendingModeDB',REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE RecoveryPendingModeDB SET MULTI_USER
EXEC sp_resetstatus 'RecoveryPendingModeDB'
Replace RecoveryPendingModeDB with your actual database name with status 'Recovery Pending'.
You can read in detail here: https://www.zubairalexander.com/blog/how-to-fix-sql-server-databases-in-suspect-or-recovery-pending-mode/
Repair SQL Server with status (Recovery Pending)
Posted by
Unknown
, Monday, June 26, 2017 at 1:25 PM, in
Words of the day
Posted by
Unknown
, Monday, May 22, 2017 at 8:29 AM, in
Permeate /pərmēˌāt/ (v)
= spread through out something.
= pervade.
Ex:
- Women have yet to permeate the world's top military roles.
- The virtual world appears to be a part of our society that is here to stay, and will more than likely continue to increase. It will permeate more of our children’s lives as they grow up, much more than ours. Remember that it is okay to monitor what your child does on the computer or smart phone.
Unleash /ˌənˈlēSH/ (v)
= release, free
Ex:
- The Air Force Still Hasn't Unleashed the Full Potential of the F-35 (Yet)
- R1bn (R1 billion) fine for unleashed dogs ‘not amusing’
While a municipal sign threatening to issue people with a R1-billion fine if they walk their animals without a leash on Sardinia Bay beach has raised a few laughs, the Nelson Mandela Bay municipality was not amused by the gaffe.
(Note: R1 is South Africa Rand currency)
Condense /kənˈdens/ (v)
= make something denser or more concentrated.
= change or cause to change from a gas or vapor to a liquid.
Render /ˈrendər/ (v)
= provide, give (a service, a help, etc.)
= submit, present, hand over, deliver for inspection or consideration
= make
= represent artistically
= translate
= perform
Ex;
- Money serves as a reward for a service rendered.
- He will render his tax return at the end of the year.
- The rain rendered his escape impossible.
- The eyes and cheeks are exceptionally rendered.
- The phrase was rendered into English.
- The character are vividly rendered.
= spread through out something.
= pervade.
Ex:
- Women have yet to permeate the world's top military roles.
- The virtual world appears to be a part of our society that is here to stay, and will more than likely continue to increase. It will permeate more of our children’s lives as they grow up, much more than ours. Remember that it is okay to monitor what your child does on the computer or smart phone.
Unleash /ˌənˈlēSH/ (v)
= release, free
Ex:
- The Air Force Still Hasn't Unleashed the Full Potential of the F-35 (Yet)
- R1bn (R1 billion) fine for unleashed dogs ‘not amusing’
While a municipal sign threatening to issue people with a R1-billion fine if they walk their animals without a leash on Sardinia Bay beach has raised a few laughs, the Nelson Mandela Bay municipality was not amused by the gaffe.
(Note: R1 is South Africa Rand currency)
Condense /kənˈdens/ (v)
= make something denser or more concentrated.
= change or cause to change from a gas or vapor to a liquid.
Render /ˈrendər/ (v)
= provide, give (a service, a help, etc.)
= submit, present, hand over, deliver for inspection or consideration
= make
= represent artistically
= translate
= perform
Ex;
- Money serves as a reward for a service rendered.
- He will render his tax return at the end of the year.
- The rain rendered his escape impossible.
- The eyes and cheeks are exceptionally rendered.
- The phrase was rendered into English.
- The character are vividly rendered.
A handy linq ForEach on List collection
Posted by
Unknown
, Monday, January 27, 2014 at 8:49 AM, in
Have you ever used MsBuild with Multi-core supported to boost the build speed of your projects (probably more than 100) to improve your productivity?
Posted by
Unknown
, Monday, September 9, 2013 at 1:36 PM, in
Have you ever used MsBuild with Multi-core supported to boost the build time of your projects (probably more than 100) to improve your productivity?
We can either build the whole solution or just specific project from Visual Studio using MsBuidl with Multi-Core supported.
I have used it for a while now I think already more than a year and happy with it.
We can print the output to VS's Build Output or print to console (I prefer the console.)
Using MsBuild to build our stuffs we can use Visual Studio at ease I knew that some environment that has less RAM might probably encounter an issue that when you build your projects/solution
from Visual Studio it just halted (or even the text/codes/tabs are mixed up when you are debugging) and you might really hate it! I do.
So using MsBuild I am happy with that so far. My productivity is better. I feel less stress when building a huge solution consisting more than 170 projects :).
To be continued, I will write a step by step on how to do MsBuild from VS.
Peace Out!
RENAME SQL SERVER database name in Multiple user mode with killing all users' session (FORCE RENAME))
Posted by
Unknown
, at 8:45 AM, in
*Note: it has to be run against database master (select on master -> new query or add use master)
DECLARE @ID INT
DECLARE @MSG CHAR(8)
While 1 = 1
BEGIN
Set
RowCount 1
SELECT
@id = spid
FROM
Master..Sysprocesses P,
Master..Sysdatabases D
WHERE
D.Name= N'MYDATABASE'
AND
D.dbid = P.dbid
IF
@@rowcount =
0
break
SELECT
@msg = 'KILL ' + convert(char(8) ,@ID)
Print
@msg
EXEC( @msg)
--break
END
GO
Alter database MYDATABASE
set MULTI_USER
with rollback immediate
exec sp_renamedb N'MYDATABASE',N'MYDATABASE_STH_ELSE'
To run Batch Script as Administrator can be a little challenge.
Posted by
Unknown
, at 7:44 AM, in
Sometimes you need batch script to run as administrator:
There is 2 alternatives:
1- Convert your batch script to exe and make exe run as administrator:
For example:
There is 2 alternatives:
1- Convert your batch script to exe and make exe run as administrator:
2- Add another batch script to open your batch script as administrator:
For example:
ExecuteDBBlank.bat will execute DBBlankExecution.bat as administrator but it requires you to enter password administrator:
ExecuteDBBlank.bat
runas /noprofile /user:PC_NAME\Administrator C:\Users\COUK\Desktop\DBBlankExecution.bat
Where PC_NAME is your PC name and your main execution batch file can be located at any directory please update yours accordingly.
Where PC_NAME is your PC name and your main execution batch file can be located at any directory please update yours accordingly.
If we click on ExecuteDBBlank.bat it will ask you for Administrator password if you enter correctly DBBlankExecution.bat will be executed:
Subscribe to:
Posts (Atom)