Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Copy database

Author  Topic 

JJins
Yak Posting Veteran

81 Posts

Posted - 2012-03-26 : 10:39:31
what is the best way to copy a database and save as a file to send or save?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-03-26 : 11:01:51
Backup the database


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

JJins
Yak Posting Veteran

81 Posts

Posted - 2012-03-26 : 11:06:39
That was not helpful
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-03-26 : 11:08:20
But it is the best posible answer.

Why is it not helpful?
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-03-26 : 11:11:32
Will this helps ?

How to: Back Up a Database (SQL Server Management Studio)
http://msdn.microsoft.com/en-us/library/ms187510.aspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-26 : 11:58:40
quote:
Originally posted by JJins

what is the best way to copy a database and save as a file to send or save?



Speaking of not being helpful

You are being kind of vague here

What is it that you exactly want to do?

Create an Excel Book with a tab for every table?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -