diff options
Diffstat (limited to 'Software/Visual_Studio/Notes')
| -rw-r--r-- | Software/Visual_Studio/Notes/Tango.Notes/DB/Repair Suspect Mode.txt | 6 | ||||
| -rw-r--r-- | Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj | 3 |
2 files changed, 8 insertions, 1 deletions
diff --git a/Software/Visual_Studio/Notes/Tango.Notes/DB/Repair Suspect Mode.txt b/Software/Visual_Studio/Notes/Tango.Notes/DB/Repair Suspect Mode.txt new file mode 100644 index 000000000..b66eca7d3 --- /dev/null +++ b/Software/Visual_Studio/Notes/Tango.Notes/DB/Repair Suspect Mode.txt @@ -0,0 +1,6 @@ +EXEC sp_resetstatus Tango_TEST; +ALTER DATABASE Tango_TEST SET EMERGENCY +DBCC checkdb(Tango_TEST) +ALTER DATABASE Tango_TEST SET SINGLE_USER WITH ROLLBACK IMMEDIATE +DBCC CheckDB (Tango_TEST, REPAIR_ALLOW_DATA_LOSS) +ALTER DATABASE Tango_TEST SET MULTI_USER
\ No newline at end of file diff --git a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj index 9f2d91731..7c0014747 100644 --- a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj +++ b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj @@ -50,6 +50,7 @@ <Content Include="Azure\Test User Credentials.txt" /> <Content Include="Azure\SQL Database.txt" /> <None Include="DB\Fix Domain User Script.bat" /> + <Content Include="DB\Repair Suspect Mode.txt" /> <Content Include="DB\DB Schema Change Log.txt" /> <Content Include="DB\Drop All Tables.sql" /> <Content Include="DB\Fix Job Corrupted Runs Start Time.sql" /> @@ -72,7 +73,7 @@ <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" /> <ProjectExtensions> <VisualStudio> - <UserProperties BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UseGlobalSettings="False" BuildVersion_StartDate="2000/1/1" /> + <UserProperties BuildVersion_StartDate="2000/1/1" BuildVersion_UseGlobalSettings="False" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" /> </VisualStudio> </ProjectExtensions> </Project>
\ No newline at end of file |