This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery models.
2007-02-27
5,180 reads
2007-02-21
1,283 reads
Microsoft has finally release service pack 2 for SQL Server 2005. Read a short commentary and get the links to download it now.
2007-02-21
8,837 reads
2007-02-20
1,544 reads
2007-02-15
1,156 reads
2007-02-13
2,755 reads
2007-02-12
1,275 reads
The SQL Server 2005 Maintenance Plan Wizard offers many core tasks and options for database housekeeping. In addition, the wizard will roll all of your selected tasks into a reusable and customizable package. Read on to learn more.
2007-02-09
2,723 reads
2007-02-08
1,331 reads
New to SQL Server 2005 is the Dedicated Administrator Connection (DAC), which provides a way to ensure you can always connect to your server. No more getting locked out of a busy server as could occur in prior versions. Wayne Fillis brings us a short tutorial on this handy new feature.
2008-05-05 (first published: 2007-02-06)
7,688 reads
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Yes, you’re reading that right, we’re going to download a report that cannot be...
hi, need to known weather fast farwand cursor is faster than a while loop...
Comments posted to this topic are about the item Economics of AI: What is...
Comments posted to this topic are about the item Poor Name Choice
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers