SQL Server

Some notes and links for MSDE, Microsoft SQL Server.
 

 

Master database

This is critical. IMHO, you should have a backup copy of the RAW mdf and ldf files. You can't start sqlserver w/o Master and a .bak does little good if you can't start sql server.

Corrupt DB - This WILL have data loss:
ALTER DATABASE dbname SET EMERGENCY;
ALTER DATABASE dbname SET SINGLE_USER
DBCC CHECKDB (dbname, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;

Physical File Notes - DRAFT:

The MDF files date modified seems to get updated to the last DBCC CHECKDB time
The LDF file date modified does not get updated as frequently. Trails by many days. Possibly last boot?  Or last resize?


Tags: mssql, sqlserver, sql server, msde, microsoft, sql express, tsql

Related Scribbles:
  • Allow SQL Password Logins MSDE
  • Attach / Detach Database OSQL Example
  • BCP Example (SQL Server)
  • Databases. MySQL, SQL Server, etc.
  • DBNETLIB -2147467259
  • Defrag All SQL Server Indexes
  • Empty MSSQL Transaction Log
  • Free SQL Server / MSDE Admin
  • Get Number of Rows in Every Table
  • Install both SQL Server 2000 and SQL Server 2005
  • List Databases MSSQL
  • Manually Insert into Identity Column SQL Server
  • Microsoft SQL Server Backup and Migration Scripts
  • MS Office
  • MSSQL - List size (on disk) of all tables in a database
  • MSSQL Table Analysis Queries
  • MSSQL Timeout
  • MSSQL trigger examples
  • MySQL "Show Tables" Equivalent in MS SQL Server
  • Now() Equivalent in MSSQL
  • Pass text to MSSQL Query
  • Prioritize queries MS SQL Server
  • Quickly Shrink SQL Server Transaction Logs
  • Rename MSSQL Server Database
  • Rename table in MS SQL (T-SQL)
  • Restore and Backup MSDE Database with TSQL via OSQL
  • Restore SQL Server 2012 database to SQL 2008
  • Search all MS SQL Database Values
  • Search Entire MSSQL Database Design
  • Simple OSQL Tutorial
  • Simple way to send email from SQL Server
  • SQL Case Example
  • SQL Express Maintenance - SQL Agent Alternatives, Scripts, etc.
  • SQL Reporting Notes
  • SQL Server - Index Notes, Clustered Indexes, etc.
  • SQL Server - List Fill Factor of all Indexes
  • SQL Server - List Largest Tables
  • SQL Server - Move a database manually via SQL
  • SQL Server - Slow Query Example
  • SQL Server 2000 - Enable remote TCP/IP Connections
  • SQL Server Profiler Notes
  • SQL Server Version to Service Pack List
  • SQL Syntax, Query Examples and Notes
  • SSMS (Formerly SQLEM) Notes


  • ID: 427
    Author:
    leonard
    Date Updated:
    2019-07-03 12:06:21
    Date Created:
    2004-03-13 00:46:33

    Edit

    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> SQL Server
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.