Can you restore database using corrupt datafiles when there is no full backup and both .mdf and .ldf are damaged? My honest answer and the one thing to try.
SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
A simple Table Partitioning tutorial for SQL Server 2005 that shows, step by step, how to horizontally partition a database table across two filegroups.
SQL SERVER – 2005 – Introduction to Partitioning
A short introduction to partitioning in SQL Server 2005: very large tables and indexes are split into smaller parts by ranges, across filegroups, for performance.
SQL SERVER – Solution – Log File Very Large – Log Full
Is your log file too big, or is the log full? Fix it in three steps: back up the log file, truncate it, then shrink it. I link my two detailed posts too.
SQL Server Layers: Protocols, Query Processor, Storage Engine and SQLOS
SQL Server layers run from the network protocols down to SQLOS and the data and log files. Here is what each layer does, and how physical architecture differs from logical architecture.
SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database
Error 3154 says the backup set holds a backup of a database other than the existing database. Use WITH REPLACE in RESTORE, or drop the old database first.
SQL SERVER – Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward
Msg 3117 means the log or differential backup cannot be restored because no files are ready to rollforward. Restore the full backup WITH NORECOVERY first.