Davids Learning


I am wanting to be able to take my work home with me, problem is I can access the server from there.

Is it possible to work with a local instance on my laptop, then when completed transfer it to another instance on a different pc

Meaning, talbes,queries,etc.

Thanks

Davids Learning




Re: Make duplicate db?

Michael Hotek


You can create a backup of the database and restore it to another machine.





Re: Make duplicate db?

Davids Learning

does that work with the express version

or would I be better of using Access

Davids Learning






Re: Make duplicate db?

Arnie Rowland

That works very fine with SQL Express.




Re: Make duplicate db?

Davids Learning

I need help with this.

How do you backup or restore to a different instance on a different machine

I am new to SQL Server.

I can from my laptop see the server and access the files and do a backup(I believe the backup ran on the server and not on mine), but how do you get the db to my instance on my laptop

Thanks

DavidsLearning





Re: Make duplicate db?

Arnie Rowland

Look in Books Online for the usage of RESTORE, and especially the WITH MOVE option.

If you don't have Books Online, download a copy here:

SQL Server 2005 Express Books Online Express Edition
http://msdn2.microsoft.com/en-us/library/ms165706.aspx







Re: Make duplicate db?

Davids Learning

I quess this is a Monday.

Is there a book for dummies

Tried to apply what I read, and I still dont get how to assign a different instance.

Is there a way to make it simplier

DavidsLearning





Re: Make duplicate db?

Arnie Rowland

You execute the RESTORE operation from the INSTANCE (after connection to that instance) where you want to install the database. (You don't 'assign an a different instance'.)

Some weeks , everyday seems like Monday...