A step by step tutorial to create a T-SQL script that can copy database schema and all objects, like stored procedures, functions, triggers, tables and views.
SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey Details
Notes from my database architecture meeting in New York and New Jersey: backup routines, index optimization and the maintenance tasks we discussed.
SQL SERVER – One Thing All DBA Must Know
The one thing all DBA must know is to backup database fully. I also answer reader questions on the best time for a backup and how often to take one.
SQL SERVER – Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database ‘yourdatabasename’. CREATE DATABASE is aborted.
Msg 1813 says CREATE DATABASE is aborted when you attach a database with a corrupt log. My step by step fix rebuilds the log and needs a server restart.
SQL SERVER – Fix : Error Msg 4214 – Error Msg 3013 – BACKUP LOG cannot be performed because there is no current database backup
Fix the SQL Server error Msg 4214 and Msg 3013, where BACKUP LOG fails because no current database backup exists. Here is why it happens.
SQL SERVER – Restore Database Without or With Backup – Everything About Restore and Backup
Everything about restore and backup readers ask: can you restore without a backup? No. Here is the right restore order and a plan to stay safe.
SQL SERVER – Recovery Models and Selection
SQL Server offers three recovery models: full, simple and bulk-logged. Here is when to select each one, based on how much data loss you can accept.