Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

SQL Server 2005 Backup

How do I do a backup with copy only?
0
Larry Brister
Asked:
Larry Brister
1 Solution
 
Paul JacksonSoftware EngineerCommented:
Can you explain a bit more what you are trying to achieve?
0
 
Ephraim WangoyaCommented:

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
 
Anthony PerkinsCommented:
>>How do I do a backup with copy only? <<
You use the COPY_ONLY clause.
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
Paul JacksonSoftware EngineerCommented:
0
 
Paul JacksonSoftware EngineerCommented:
0
 
Larry Bristersr. DeveloperAuthor Commented:
Thanks..
Put me on the right track and found this link

http://www.mssqltips.com/tip.asp?tip=1075
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now