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
Solved

SQL Server 2005 Backup

Posted on 2011-03-23
6
273 Views
Last Modified: 2012-05-11
How do I do a backup with copy only?
0
Comment
Question by:lrbrister
6 Comments
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 35203159
Can you explain a bit more what you are trying to achieve?
0
 
LVL 32

Expert Comment

by:ewangoya
ID: 35203540

If you only want to do a copy of the database.
First take the database offline or detach it
Copy all the files for the database (.mdf, .ldf .ndf if any) to your new location
Reattach your database to the server

Now
All this is not worth it, Just take a backup of the database and copy it wherever you want
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 35203697
>>How do I do a backup with copy only? <<
You use the COPY_ONLY clause.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 29

Accepted Solution

by:
Paul Jackson earned 500 total points
ID: 35203706
0
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 35203715
0
 

Author Closing Comment

by:lrbrister
ID: 35205890
Thanks..
Put me on the right track and found this link

http://www.mssqltips.com/tip.asp?tip=1075
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

789 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