Solved

Urgent need for backups on Windows 2008

Posted on 2014-12-30
3
115 Views
Last Modified: 2015-01-19
I just took over a customer with a Windows 2008 server (not R2) and he has 3 databases on the server and lots of business files. No backups in place whatsoever. One is a pervasive database (which is easy) and two are MS SQL databases.

With the Windows 2008 built in backup does it properly backup the MS SQL databases when they are mounted?

What is the best and quick way to get these databases backed up until a plan is in place on how to proceed?
0
Comment
Question by:Gerhardpet
3 Comments
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 250 total points
ID: 40524418
If you have an available -- known to SQL already -- drive with enough space free, just do stand-alone backups:

BACKUP DATABASE db1 TO DISK = 'x\full\path\to\backup\file\db1.bak' WITH COMPRESSION, INIT
BACKUP DATABASE db2 TO DISK = 'x\full\path\to\backup\file\db2.bak' WITH COMPRESSION, INIT
BACKUP DATABASE db3 TO DISK = 'x\full\path\to\backup\file\db3.bak' WITH COMPRESSION, INIT
0
 
LVL 16

Assisted Solution

by:Ivan
Ivan earned 250 total points
ID: 40524422
Hi,

there is no need to use windows backup for MS SQL. Just log in to SQL and backup from there.
Aither via GUI, right click on DB, and choose backup, of with query, in form Backup database <name of database> to disk='D:\path\database1.bak'

After that you can create backup plan within sql. From simple, like backup everyday, one time per day, or something complicated like backup 1x per day and backup log every few minutes (backing up a log requires that db is in full recovery model).. You can check model by right click on DB, and properties..

Here is a link to start you up> http://www.rackspace.com/knowledge_center/article/create-a-maintenance-backup-plan-in-sql-server-2008-r2-using-the-wizard 

Regards,
0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 40558182
There were 10+ MS SQL databases to be backed up so I ended up using SynBack Pro. But both suggested mothods worked as well.

Don't ask me why 10 database...I'm still trying to sort everything out but somehow they have a need to have a number of CRM databases.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question