Copy Network SQL Server to Local Instance

[LonnieJohnson]

Here is something that sounds like it should be easy but I know it is not. I have a laptop that I need to carry around for demos. I want to register COPY of a network SQL Server instance.

Does that make sense? Is it easy to do? What is my first step?

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[bborissov]

Not sure what you meant with COPY of SQL Server.
If you just want to COPY SQL Server files and Databases that didn't work. You should INSTALL your own SQL Server instance on that computer.
To transfer Databases from Main SQL Server to your own two choices:
1.
Create an e,pty database on you computer with the same name as database on Main SQL Server.
Backup that Database on Main server and then restore that backup on your computer.

2.
Detach that Database from your main SQL Server
Copy Database files (mdf and LDF) on some device (CD, Flash whatever)
Attach it back on main SQL Server
Copy that database on your computer and Attach it on local SQL Server instance.

Repeat these steps for all databases you need




Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[SQLBill]

It sounds like you need to have a copy of a production database so you can travel with it and demo it to other clients.

You still need to do as bborissov stated. Install a valid version of SQL Server on your laptop, do a backup of the production database and restore it on your laptop.

One issue will be database size. Is your laptop drive large enough to hold the database files?

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[LonnieJohnson]

Thanks guys. I appreciate both of your responses.

I have the two database backed up that I need. My new problem is that there was nothing registered on the laptop. I tried to register a local SQL Server and it tells me that it cannot connect. So I cannot restore my databases because I have no where to put them. I used the registration wizard.

Any thoughts? My database guy no longer works here and I am having to become a DBA real fast.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[bborissov]

O!
What SQL Server you use?
Did you have SQL Server installed on your computer?

What registration wizard?


Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[LonnieJohnson]

I am using SQL Server 2000.

In the Enterprise Manager Console Root directory there is...


Microsoft SQL Servers
SQL Server Group
(No Itmes)


I right click on SQL Server Group to try and add a local instance of a SQL Server and select the option for New SQL Server Registration...

This is when the wizard starts.


ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[LonnieJohnson]

Ok. Instead of using the wizard I set it up manually. I just called it LOCAL in all caps. It seemed to register but when I try to click on it and exand the node it gives me the following message...


A Connection could not be established to LOCAL

Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect())...

Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the LOCAL node) and try again.


Thanks.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[bborissov]

I don;t know, but I always prefer to calll SQL Server by its name instead of calling it with local, localhost, 127.0.0.1 etc.
That way you always HAVE to know the SQL Server name
What if you want to connect to that computer on some other one? How did you know the SQL Server instance?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[LonnieJohnson]

See that is where I am inexperienced. Maybe I don't have SQL Server installed properly. I don't even get any local options. That's all I want is a local version of SQL Server on this laptop.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[SQLBill]

What version of OS do you have?

What version of SQL Server did you install/attempt to install?

You may have only installed the SQL Server Client Tools. If so, you don't have SQL Server installed and cannot restore/create or do anything else with databases on your laptop. The Client Tools would allow you to connect to a SQL Server instance on another machine that has it installed.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875