high availability SQL Server database backup tutorial

Hello guys!

Today I’m here with a simple but very powerful tool to backup high availability SQL Server databases, that almost ever can be shut down to perform an backup.

I work with oracle, but we have a huge sql server database that we are responsible about disk usage, so I decided to post this help to SQL Database buddies too.

If you need a quick backup (takes like 5 minutes to backup a 20gb+ database) and your database can’t be shut down, this is one option….

Those commands are SQL Commands, I run then on SQL Analyser.

USING TAPE
BACKUP DATABASE [MydataBase] TO Tape0 WITH NOINIT,NOWNLOAD,NAME = N’Bkp_MydatabseFull’,stats=10,NOFORMAT

USING DISK (pendrive by example)
BACKUP DATABASE [MydataBase] TO DISK = N’F:\MyBkpFolder\MydataBase.bak’ WITH NOFORMAT,INIT

You can use both too if necessary, but I just know the usage to same kind of target (DISK or Tape) by example.

BACKUP DATABASE [MydataBase] TO DISK = N’F:\MyBkpFolder\MydataBase.bak’, DISK = N’D:\MyBkpFolder\MydataBase.bak’ WITH NOFORMAT,INIT

I’ll upload soon more two tutorials that will be:

How get content of a Tape on windows (worked to me on Windows Server 2003) and how to move Disk backups to Tape

I hope it be useful to somebody

By the way, to know a few  parameters and more examples visit http://msdn.microsoft.com/en-us/library/ms186865.aspx (great resource)

See ya!