SQL Server has a rock solid backup routine that works every time. However the schemes used to implement backups with maintenance plans, Enterprise Manager, etc., are not a smooth or as flexible as what most people require. Author Eli Lieba brings us his strategy and code for ensuring that each database is backed up how he needs it to be, whether a full or differential backup.
2004-10-19
11,315 reads
SQL Server 2000 integrates a number of features to work with XML data and SQL Server 2005 should expand upon that. However the SQL Server 2000 extensions for working with XML data in T-SQL are not that mature. New author Eli Leiba looks at how he can traverse an XML file using T-SQL code.
2004-09-20
13,001 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
hi we run 2019 std but i'm testing this on 2016. following some old...
If you run this code it creates a 2 row cursor loop. Within the...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers