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
 how to do a copy of my db in sql server 2005

Author  Topic 

vitaly87
Starting Member

13 Posts

Posted - 2010-03-27 : 07:26:25
hello all!
i just want to do a copy of my db. i am a student and just cant do that, i tried to do a backup but its not working. i want to copy my db to work with my project in c# on other computer. can you say how can i do that?

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-03-27 : 07:37:49
Try the below link

[url]http://www.exforsys.com/tutorials/sql-server-2005/sql-server-database-backup.html[/url]

Vaibhav T
Go to Top of Page

vitaly87
Starting Member

13 Posts

Posted - 2010-03-27 : 07:51:19
quote:
Originally posted by vitaly87

hello all!
i just want to do a copy of my db. i am a student and just cant do that, i tried to do a backup but its not working. i want to copy my db to work with my project in c# on other computer. can you say how can i do that?



i tried to do that but i have a strange message TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'M-FAC95211BECB4\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
Go to Top of Page

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-03-27 : 09:15:38
By the error description it shows that you are trying to restore the database instead of backup.
and in your original post you told you are trying to take the backup.


Vaibhav T
Go to Top of Page

vitaly87
Starting Member

13 Posts

Posted - 2010-03-27 : 10:07:25
ok i tried to do what you said but when i click to do a backup and click ok it print me an error:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Backup failed for Server 'M-FAC95211BECB4\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Cannot open backup device 'C:\db1'. Operating system error 5(Access is denied.). (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
Go to Top of Page

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-03-28 : 13:25:54
This seems the particular path is not accessible try to give original application path C:\Program Files\Microsoft SQL Server\....
by default it let you select this path. then copy paste the backup where ever you want.

Vaibhav T
Go to Top of Page
   

- Advertisement -