I was looking for some simple Data Backup solutions, I try few software but they all are paid. But after a long search I have found a free utility from Microsoft known as ROBOCOPY (now inbuilt in Windows7). This ROBOCOPY is command based but the GUI version is also available on Microsoft website.
The Syntax of ROBOCOPY is very simple:
ROBOCOPY.exe source destinations /MIR
- /MIR is used for mirroring the Data
For example
Robocopy.exe c:\data d:\Backup /MIR
The above command will mirror the data in c:\data with d:\Backup
you can also exclude the files to being copied, for that you need to use /XF (exclude files) switch.
How to use /XF
For example if you want to exclude mp3, avi files to copy then syntax is :
In this Post I am going to take you through the 5th system database which is available right from SQL Server 2005. As we know till SQL Server 2000 there are four system databases available and they are master, model, msdb and tempdb databases. In SQL Server 2005 Microsoft has introduced a new system database to the SQL database engine called Resourcedatabase (real name for this database is mssqlsystemresource). This database is hidden to the users.
Why Microsoft Introduced Resource DB?
Resource database is a read-only and hidden database. Resource DB physically contains all the system objects that accompanies with SQL Server. Logically all objects present in sys schema exist in each DB. The Resource database does not contain user data or user metadata.
Tail Log Backup in SQL Server 2000 or in SQL Server 2005 when Master DB or User DB is corrupted\Not available
AS we know, we can take the Tail Log Backup if the database file is damaged, provided that the transaction log file is still available. But what will you do if the master database is also damaged; then you can rebuild and restore the master database first, and then back up the last active transaction log of the unavailable database. For example, both the data file and the master device might be on damaged media. However, if a master database is not available, you can take Tail Log Backup of the database by using the below mentioned method.
Cloud Computing is very HOT today and many organizations have started providing these services. So I thought to share some knowhow with SQL Group about the same. May be you’ll get an opportunity to work in this environment soon.
The Windows Azure Platform is an Internet-scale cloud computing and services platform hosted in Microsoft data centers. The Windows Azure Platform includes the foundation layer of Windows Azure as well as a set of developer services which can be used individually or together.
The Windows Azure Platform comprises the following developer services:
