Backup Types SQL Server 2008 allows you to create four different types of backups: Full Backups Differential Backups Transaction log Backups Filegroup Backups Full Backups A full backup captures all pages within a database that contain data. Pages that do not contain data are not included in the backup. Because it is more common to [...]
Archive for the ‘SQL Server’ Category
18 Jun
SQL Server Data Warehousing concepts Video
An introduction to SQL Server data warehousing concepts Data warehousing Concepts Relational warehouse Concepts Multi-Dimensional Concepts Data Warehouse Components Data Sources ETL Relational Data warehouse (SQL Server) Dimensional Data warehouse (Analysis Services) Graphical User Interface Tools Use SQL to query relational warehouse Use MDX (Multi dimensional expressions to query cubes) Related articles by Zemanta Sql [...]
17 Jun
Examining data files when SQL Server tempdb is full
Source Link What does it mean when the tempdb is full? When SQL Server’s tempdb is full, upper management will often demand a fix, a group of developers will frantically deflect blame and junior DBAs will become afraid to touch anything at all. As I tell administrators, the first rule of thumb is simple: Keep [...]
