Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > Backup and Restore


Search:
What's New - What's Hot
Database Backup to / Restore from Remote Server - SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 12  |  Today: 0Author: PandianS      Rating:  
Read Reviews | Write Review |  Your 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....

Automating Backups on SQL Server Express Version  Version: 0.00     Price: $0.00  
Total Hits: 32  |  Today: 0Author: Raymund Macaalay      Rating:  
Read Reviews | Write Review |  Your 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....

Backup all databases on server  Version: 0.00     Price: $0.00  
Total Hits: 17  |  Today: 0Author: thanhtungo      Rating:  
Read Reviews | Write Review |  Your Rating: 

T-SQL scripts: Backup all databases on server with compress feature of SQL Server 2008...

Auto generate SQL Server database restore scripts     
Total Hits: 215  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your 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...

The Road to Recovery     
Total Hits: 615  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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....

Automated Source Safe Backups  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: Conor Hunt      Rating:  
Read Reviews | Write Review |  Your Rating: 

Recently I became tired of manually backing up a source safe database by going into the source safe administrator and going through the manual backup procedure. I decided to automate the process....

SQL Server Integration Services (SSIS) – Part 24 – Delete Remote File using FTP Task in SSIS Package  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: KarthikAnbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we are going to see on how to use a FTP task in SSIS package to delete a remote file using FTP Task in SSIS packaging.

To follow my series of articles on SSIS packages refer to the below URL’s...

SQL Server Integration Services (SSIS) - Backup Database task in SSIS and Send Mail  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: Karthikeyan Anbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we are going to see on how to use a Backup Database task to create an execution plan in SSIS to take a database backup. This task will be very helpful for the DBA's to maintain the database automatically by creating the package and using it across the servers. This task has many options to do a Full, Differential backups based on our requirement we can go ahead and use the respective option. Let's jump into the steps on how to create and use the backup database task....

Installing Windows Server Backup  Version: 0.00     Price: $0.00  
Total Hits: 16  |  Today: 0Author: admin      Rating:  
Read Reviews | Write Review |  Your Rating: 

Despite the Windows Server Backup being listed in Administrative Tools, the Windows Server Backup feature will still need to be installed. The easiest way to install Windows Backup tools is by using Add Features in the Server Manager. For Windows Server Core installations, installing with PowerShell is the preferred method....

Backup Compression - SQL Server 2008  Version: 0.00     Price: $0.00  
Total Hits: 11  |  Today: 0Author: PandianS      Rating:  
Read Reviews | Write Review |  Your 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....

Monitor Your Database Servers with DTS, Part 1: Backup SLA Report  Version: 0.00     Price: $0.00  
Total Hits: 13  |  Today: 0Author: Neeraj Nagpal      Rating:  
Read Reviews | Write Review |  Your Rating: 

It is difficult to keep track of critical things like backup, space, and error logs in large environments. Different database management tools from third party vendors can help you monitor these but the tools are normally expensive. There is an inexpensive alternative. In this series of three articles, I will describe how to monitor a large number of servers from a centralized location using Data Transformation Services (DTS). DTS is a wonderful tool that comes free with all SQL Server installat...

Importance of Database Backups and Recovery Plan  Version: 0.00     Price: $0.00  
Total Hits: 12  |  Today: 0Author: Ashish Kumar Mehta      Rating:  
Read Reviews | Write Review |  Your 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...

Backup System Databases Using Maintenance Plans  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: Ashish Kumar Mehta      Rating:  
Read Reviews | Write Review |  Your Rating: 

System databases are an integral part of SQL Server, as SQL Server is dependant on the System Databases for functionality. Database Administrators should make sure that all the system databases are part of their day to day backups. Most importantly, database administrators should take full backup of all the system databases immediately after they have applied any Hotfixes or Service Packs. Backups of system databases will let you restore and recover the SQL Server system in the event of system f...

Backup User Databases Using a Maintenance Plan  Version: 0.00     Price: $0.00  
Total Hits: 11  |  Today: 0Author: Ashish Kumar Mehta      Rating:  
Read Reviews | Write Review |  Your 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...

Create Backups without Breaking the Database Backup Sequence  Version: 0.00     Price: $0.00  
Total Hits: 11  |  Today: 0Author: Ashish Kumar Mehta      Rating:  
Read Reviews | Write Review |  Your 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...

Windows Server 2008 R2 Backup and Restore  Version: 0.00     Price: $0.00  
Total Hits: 12  |  Today: 0Author: admin      Rating:  
Read Reviews | Write Review |  Your Rating: 

Every admin should make backups. That’s just a fact. But what backup software should we use? Many administrators look for a third-party backup solution, however Windows Server ships with a solid and built-in solution – Windows Server Backup (the entirely new face of NTBackup)....

Using SMO for Backup, Restore and Security Purposes  Version: 0.00     Price: $0.00  
Total Hits: 39  |  Today: 0Author: niki_mbr      Rating:  
Read Reviews | Write Review |  Your Rating: 

Finally, I have decided to post my first article here. So I expect some feedback from you.

Thank you in advance!

I will try to explain the ways in which you can use Server Management Objects to perform some administrative tasks with SQL Server 2005 using C#.

I use some of this code for automation of the deployment of our projects. And may be I will post another article on this subject (Deployment Automation)....

SQL Database Restore  Version: 0.00     Price: $0.00  
Total Hits: 28  |  Today: 0Author: Ahmet Göktas      Rating:  
Read Reviews | Write Review |  Your Rating: 

This application is third party tool for creating T-SQL scripts for database restore operations.

You can restore a database from the SQL Server Management Studio GUI, but you cannot restore a protected backup file with MEDIAPASSWORD! In that case, you must write a SQL string, but that is very boring....

SQL Server 2000/2005: Automated Database Backups and Restorations  Version: 0.00     Price: $0.00  
Total Hits: 39  |  Today: 0Author: Neeraj Kr      Rating:  
Read Reviews | Write Review |  Your Rating: 

The database server is the heart of information storage for the enterprise, so special care must be taken in managing this critical resource. In case of a problem, it must be addressed quickly, efficiently, and correctly, or an organization stands to suffer critical losses....

SQL Server Cheat Sheet - FULL Backup  Version: 0.00     Price: $0.00  
Total Hits: 47  |  Today: 0Author: beyondrelational.com      Rating:  
Read Reviews | Write Review |  Your Rating: 

Creating a Full Database Backup to a Disk File...


1  2  3  4  5  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net