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
 backup using developer edition

Author  Topic 

dunce
Starting Member

4 Posts

Posted - 2007-01-02 : 15:18:16
I have sql server developer edition on a computer at home. I would like to back up the database onto a separate device (in case my computer blows up or something). So I'm thinking of setting up a little home network and backing up the database onto another computer or maybe onto a network drive. Remembering that developer edition is only licensed for one user, is there anything to stop me doing this? I will not be in breach of the licence, as it will only be me using the data. However, I have the feeling that the developer edition is not set up to work with networks.

Can anyone help me out please?

JoeNak
Constraint Violating Yak Guru

292 Posts

Posted - 2007-01-02 : 15:55:45
Developer Edition has the same features as Enterprise Edition, it won't be a problem.
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-01-02 : 16:09:15
normally you would backup to a local disk, and then copy the backup to a network share. that way the backup doesn't fail if the network goes down during the backup process.


www.elsasoft.org
Go to Top of Page

dunce
Starting Member

4 Posts

Posted - 2007-01-02 : 16:53:48
Thanks both, I'll try it out.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-01-03 : 03:32:40
In case it helps: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=How%20Backup%20works,What%20type%20of%20backup%20should%20I%20use,Automating%20Backups,Backup

Kristen
Go to Top of Page

dunce
Starting Member

4 Posts

Posted - 2007-01-03 : 14:05:49
Thanks - I read them before posting my question. They were useful background information, but didn't answer the specific question.

Btw, congratulations on a great forum. I had a chance to have more of a look around today.
Go to Top of Page

dunce
Starting Member

4 Posts

Posted - 2007-01-10 : 06:02:36
I set up my home network, including a network drive which I have now used to back up a bunch of Excel, Word etc files. I have also used the method suggested by jezemine to back up my SQL database. Thanks jezemine!

I would like the option of being able to back up directly to the network drive. However, when I go to set up the network drive as the Backup Device for my SQL database, I cannot see it. I can only see my local C drive. Can anybody suggest what I am doing wrong?

Thanks in advance
Go to Top of Page
   

- Advertisement -