|
|
|
|
|
Total Hits: 156 | Today: 0
|
Author: Tim Ford
|
Rating:
|
|

There is a multitude of data to be mined from within the Microsoft SQL Server system views. This data is used to present information back to the end user of the SQL Server Management Studio (SSMS) and all third party management tools that are available for SQL Server Professionals. Be it database backup information, file statistics, indexing information, or one of the thousands of other metrics that the instance maintains, this data is readily available for direct querying and assimilation int...
|
|
|
|
Total Hits: 928 | Today: 0
|
|
Rating:
|
|

SQL Server's powerful backup and restore capability offers reliable protection for your data. If you have an effective backup-and-restore strategy, you can sleep well at night knowing that if a problem occurs, you can recover from it with minimal downtime and minimal disruption to your users. Here are 11 tips for getting the most out of the backup and restore utility that comes with SQL Server....
|
|
|
|
Total Hits: 428 | Today: 0
|
Author: Shabdar Ghata
|
Rating:
|
|

Whenever we want to backup or move SQL Server database, most of us prefer to use regular backup utility which is available through Enterprise Manager in SQL Server 2000 or Management Studio in SQL Server 2005. Limitation of using Enterprise Manager or Management Studio is we have to use either complete or differential backups. This is a very tedious task when we want to backup only a small portion of a large database. For example, in my database I would like to take backup of only 15 tables out ...
|
|
|
|
Total Hits: 242 | Today: 0
|
Author: John Charles Olamendy
|
Rating:
|
|

This article is intended to cover one of the most critical responsibilities of database administrators in order to maintain data integrity. I will explain with some examples the main concepts of data backup and recovery in different database management systems....
|
|
|
|
Total Hits: 88 | Today: 0
|
Author: Jeremy Kadlec
|
Rating:
|
|

Needless to say, backups are one of the most critical aspects of a SQL Server environment and a Database Administrators (DBA) last line of defense to resolve a critical problem. As a DBA, how many times have backups saved you? Even with numerous advancements with RAID and High Availability solutions, backups continue to serve an integral component for DBAs....
|
|
|
|
Total Hits: 271 | Today: 0
|
Author: Greg Robidoux
|
Rating:
|
|

One of the most important aspects for a database environment is ensuring reliable backups are being executed and a dependable recovery plan is established in the event of a system failure or data corruption. Several options are available for defining your backup and recovery model and your choices will determine the reliability and the amount of data loss your company can acceptably incur....
|
|
|
|
Total Hits: 383 | Today: 0
|
Author: Mike Aubert
|
Rating:
|
|

Welcome to the tenth article in my series SQL Server Administration in 15 Minutes a Week. Last week we finished creating a disaster recovery plan. This week we are going to look at how to restore a database in order to test our plan. We will also cover some of the other database backup/restore options that were not covered previously. The topics for this week include: - Restoring from a backup - Other backup options Restoring a database from a file or tape backup is quite simple, but th...
|
|
|
|
Total Hits: 248 | Today: 0
|
Author: Mike Aubert
|
Rating:
|
|

Welcome to the ninth article in my series SQL Server Administration in 15 Minutes a Week. Last week we started to create a disaster recovery plan. This week we are going to finish working on our disaster recovery plan. The topics for this week include: - Creating a Disaster Recovery Plan - Continuation Last week we decided on how often to backup our database, now we must decide where to backup our database. The first option available is to backup directly to tape from SQL Server. On the pl...
|
|
|
|
Total Hits: 349 | Today: 0
|
Author: Mike Aubert
|
Rating:
|
|

Welcome to the seventh article in my series SQL Server Administration in 15 Minutes a Week. Last week we learned what T-SQL is and we also saw how the transaction logs are used to track changes in the database. This week we are going to look at how to backup our databases. The topics for this article include: -- Why Backups are important -- Database Backup Types -- Database Recovery Models -- Making a backup...
|
|
|
|
Total Hits: 429 | Today: 0
|
Author: Joe Chang
|
Rating:
|
|

For the last several weeks, I have been working with Imceda (now Quest Software) on improving the performance of LiteSpeed for SQL Server, particularly for high–end storage systems. This report represents my assessment of LiteSpeed performance characteristics. I am an independent consultant, so this report does not represent the views or claims of Quest. All of the tests were conducted using publicly available tools, and can be reproduced with reasonable accuracy....
|
|
|
|
Total Hits: 353 | Today: 0
|
Author: Gregory A. Larsen
|
Rating:
|
|

Every once in a while, an event might happen that corrupts a database. We have all made a stupid mistake at least once that has trashed a database. When this happens what do you do? If you do not have a database backup, then you had better own up to the problem you caused and tell your boss that you screwed up. If you do have at least a complete database backup then you most likely will be able to recover the corrupted database, up to the point that you corrupted the data. This article will disc...
|
|
|
|
Total Hits: 367 | Today: 0
|
Author: Steven Warren
|
Rating:
|
|

I recently had the opportunity to work with a new piece of software for my SQL Server backups. The product is called SQL Backup and it is made by Red Gate Software. With SQL Backup, you can perform the following: Compressed backups, Perform faster online backups, Encrypt SQL Server backups with 128 bit Rijndael encryption, Command line interface....
|
|
|
|
Total Hits: 588 | Today: 0
|
|
Rating:
|
|

Have you ever wondered how to recover just one table instead of restoring the entire database? You have plenty of options, from SQL Server 6.5's LOAD TABLE command to SQL Server 2000's recovery models. Choose the method that works best for you....
|
|
|
|
Total Hits: 140 | Today: 0
|
Author: Narayana Vyas Kondreddi
|
Rating:
|
|

This is one of the common requests I see in the newsgroups. People often wonder how they could search and replace data, that is stored in their tables. While this doesn't sound like a very good thing to do, there are some genuine situations, where 'find and replace' functionality is needed. For example, spelling mistakes in the column values, or moving a database from one location to another, and wanting to replace all location specific content. Is there a built-in 'Global Search and Replace'...
|
|
|
|
Total Hits: 262 | Today: 0
|
Author: Mike Aubert
|
Rating:
|
|

Welcome to the eighth article in my series SQL Server Administration in 15 Minutes a Week. A few weeks back we took our first look at Database backups. This week we will quickly review the recovery models and start to look at how to prepare a disaster recovery plan. The topics for this week include: - Recovery Models Review - Creating a Disaster Recovery Plan Something you will start to notice as we get further into SQL Server is that most settings and options are more of a balancing ac...
|
|
|
|
Total Hits: 510 | Today: 0
|
Author: Shabdar Ghata
|
Rating:
|
|

Whenever we want to backup or move SQL Server database, most of us prefer to use regular backup utility which is available through Enterprise Manager in SQL Server 2000 or Management Studio in SQL Server 2005. Limitation of using Enterprise Manager or Management Studio is we have to use either complete or differential backups. This is a very tedious task when we want to backup only a small portion of a large database. For example, in my database I would like to take backup of only 15 tables out ...
|
|
|
|
Total Hits: 160 | Today: 0
|
|
Rating:
|
|

While I right away want to say to you - I'm not getting into the "what's-best-MySql-or-Sql-Server"-war with this article - instead I just wanted to tell you what happened to me and my clients lately and how surprised I was to see that both MySQL and MS SQL Server 2000 solved my problems pretty easily. This is also a true story which points out some things to pay attention to when it comes to backing up data....
|
|
|
|
Total Hits: 1 | Today: 0
|
Author: Raymund Macaalay
|
Rating:
|
|

Automating Backups on SQL Server Express Version is not possible as it does not have a SQL Server Agent installed with the instance, but don't worry as you can still do backups but manually using the free SQL Server Management Studio Express or automated by using a combination of scheduled task (Win2k3 below) / Task Scheduler (Win2k8) and the SQLCMD utility....
|
|
|
|
Total Hits: 3 | Today: 0
|
Author: thanhtungo
|
Rating:
|
|

T-SQL scripts: Backup all databases on server with compress feature of SQL Server 2008...
|
|
|
|
Total Hits: 3 | Today: 0
|
Author: Rahul Kumar Saxena
|
Rating:
|
|

In this article I am going to show how we can show all Data Server in a network and on selecting a Data Server, how to show all DataBase of that selected Data Server and how to take backup of selected database on a particular location by code....
|
|
|
|
|
|