|
|
|
|
|
| | Total Hits: 1 | Today: 0 | Author: PandianS | Rating:  |
| | 
Backup and Restore is one of the high availability model. In this article, I would like to perform Backup on Remote server and Performing Restore the backup file(.bak) from Remote Server into local SQL Server.
How to access the Remote Server shared path from local server ?
We can use Map network drive with Remote Server.... |
| | Total Hits: 23 | 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: 191 | Today: 0 | Author: Edwin Sarmiento | Rating: |
| |
I have been hearing about the Resource database in SQL Server 2005 and that it should be included in our system database backups. Unfortunately, this database does not show up in SQL Server Management Studio for me to include in my database backups. How do we backup and restore the Resource database? The Resource database (shortly referred to as RDB) is a hidden, read-only database that contains all the system objects that are included with SQL Server 2005. This is the reason why it does not app... |
| | Total Hits: 291 | 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: 2 | Today: 0 | Author: vilas gite | Rating:  |
| |
Here you will see how to Create Backup File Dynamically for MS Excel.... |
| | Total Hits: 1 | Today: 0 | Author: PandianS | Rating: |
| |
I would like to say one small story about "SQL Server Backup Compression". Most of us worry about Database Backup Time taken, Free Space required for the backup file, Etc. We have one option called Backup Compression and we are going to discuss about it in this article.... |
| | Total Hits: 3 | Today: 0 | Author: Ashish Kumar Mehta | Rating: |
| |
In this fast moving world, data is the heart and soul of any enterprise. It has become an essential task for organizations around the world to protect their data. Database Administrator's have a tough job to implement database backup and disaster recovery plans. Backing up your databases can protect an organization against the accidental loss of data, database corruption, hardware/operating system crashes or any natural disasters. Unfortunately if you don’t have proper database backups then you... |
| | Total Hits: 2 | Today: 0 | Author: Ashish Kumar Mehta | Rating: |
| |
Data is the heart and soul of any enterprise. It has become an essential task for organizations around the world to protect their data. Database Administrators have a tough job to implement right database backup strategies and disaster recovery plans. Backing up your user databases can protect an organization against the accidental loss of data, database corruption, hardware/operating system crashes or any other natural disasters. Unfortunately if you don’t have proper database backups then you... |
| | Total Hits: 2 | Today: 0 | Author: Ashish Kumar Mehta | Rating: |
| |
Development or Testing teams often request Database Administrators to provide a copy of a full database backup of a production database. When such a request comes in, I have seen in many organizations that the junior database administrators will quickly perform a full database backup and copy the backup files to the specified shared location and finally they go ahead and remove the special full backup files from the production server to save the disk space. However they don’t realize that this a... |
| | Total Hits: 71 | Today: 0 | Author: Randy Dyess | Rating: |
| |
Every now and then we all have to reread something we may already know because frankly, if you are like me, you can't keep everything in your head. I tend to go back over tips and tricks, and even database concepts, when I have time so I will maybe remember enough about them so when a problem arises, I at least know where to go look and find the answer. It is with this in mind that I want to write about my latest re-education attempt.... |
| | Total Hits: 47 | Today: 0 | Author: Hans Candra | Rating: |
| |
The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server. The program typically contains SQL statements to create the table, populate it, or both. However, mysqldump can also be used to generate files in CSV, other delimited text, or XML format. The mysqldump utility can usually be found in c:\mysql\bin on Windows operating systems, and in the /usr/local/mysql/bin dir... |
| | Total Hits: 111 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
One of the ongoing challenges of a DBA is to backup and restore databases. Backups are done on an automated schedule, but restores can take on many different versions, you may need to restore a production database, restore a development or test database or just create another copy of the database somewhere else. There are several ways of automating the restore process and creating a script, but this approach shows a way this can be done by just reading the contents of a directory for the backu... |
| | Total Hits: 183 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
Many of our SQL Server releases include data changes, not just code changes. In some respects the SQL Server data changes are more of an issue to manage than the code changes, because we can easily isolate the code changes and roll them back as needed. With the data changes if we add a simple lookup value to a table and update particular records we can do some detective work and trace back the data. It takes time, but we can typically trace it back.... |
| | Total Hits: 168 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
At some point, a detrimental command will probably be issued against one of your databases and you will need to recover the lost data. There are several actions that you might be able to take to recover the lost data, but what option makes the most sense. One option that SQL Server offers is the ability to do point in time restores of your data in order to restore your database back to the point right before that detrimental command was issued. So what are the steps in order to do a point in ... |
| | Total Hits: 150 | Today: 0 | Author: Edwin Sarmiento | Rating: |
| |
As a lot of line-of-business applications are being built with SQL Server 2005 Express Edition as their backend database, we need to make sure that we backup the system and the user databases running on these instances. Unfortunately, SQL Server 2005 Express Edition does not come with SQL Agent which we would normally use to create a database maintenance plan to backup all the databases. How do we perform a backup of our system and user databases in SQL Server 2005 Express Edition similar to how... |
| | Total Hits: 201 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
When a failure occurs you need to act quickly to possibly restore your database. When you are performing both full and transaction log backups there are multiple files that will need to be restored and therefore your restore script could get quite long and tedious to write. When using Enterprise Manager or SQL Server Management Studio the GUI gives you the list of files that should be restored, but what if you need to do this manually or you would rather have a script to perform the restore pr... |
| | Total Hits: 271 | 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: 104 | 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: 406 | 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: 265 | 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... |
|
|
|
|
|
|
|
|
|
|
|
|
|