Solved

SQL Server Fast Backup and Restore ?

Posted on 2011-03-17
2
429 Views
Last Modified: 2012-05-11
Hello Gurus,
I am testing an ERP solution that has the a SQL Server 2008 DB.

I would like to backup the database run some tests and restore...do this
forth and back operations....
But I am not very familiar with SQL 2008 .

Can someone point me to a simple tutorial how to backup & restore  a SQL DB ?
0
Comment
Question by:ammounpierre
2 Comments
 
LVL 10

Accepted Solution

by:
wmeerza earned 250 total points
ID: 35162599
0
 
LVL 15

Assisted Solution

by:Aaron Shilo
Aaron Shilo earned 250 total points
ID: 35171856
folow this link for a graphical step by step guide for backup and restore.

http://www.linglom.com/2008/01/12/how-to-backup-and-restore-database-on-microsoft-sql-server-2005/
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

914 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now