Solved

Urgent need for backups on Windows 2008

Posted on 2014-12-30
3
124 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

734 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