Solved

SQL SERVER BACKUP

Posted on 2013-06-10
5
11 Views
Last Modified: 2015-06-23
Hi,
i was wondering if i could use clonezilla  to make an iso copy of my entire raid sql server.
if not how do i have a snap shop of the server 2008 at the mooment?
0
Comment
Question by:drsmk80
  • 3
5 Comments
 
LVL 11

Accepted Solution

by:
wrmichael earned 500 total points
ID: 39235694
SQL Server is transaction and that means you should use SQL to create a backup file and then backup the backup file you created.

It is always in a "moving" or transaction state and a snapshot may not work as you expect.
0
 
LVL 11

Expert Comment

by:wrmichael
ID: 39235698
0
 
LVL 11

Expert Comment

by:wrmichael
ID: 39235707
Here are some other related comments to using images as backup for SQL:

http://communities.vmware.com/thread/438617?start=0&tstart=0
0
 
LVL 34

Expert Comment

by:Seth Simmons
ID: 40845706
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
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 the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
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…

830 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