February 27, 2006 at 10:19 am
First of all let me explain that I am a complete newbie to this SQL stuff. I am in the process of reading a book, and followed the books suggestions for what I want to do, but it doesn't work. I know this has been covered several times in this forum, but no one post in particular covered exactly what I want to do.
I want to copy the database from the server to my local machine.
First, do I need to have SQL running on my machine in order to copy the database? I do have Enterprise Manager running, does that mean SQL Server is running locally?
Secoond, I tried using the Copy Wizard, but when I get to the target list, my local machine is not listed. How do I get it listed so I can copy the database?
I hope my questions are not too stupid... but then I'd be stupid if I didn't ask questions.
Thanks in advance for your help...
David
February 27, 2006 at 10:35 am
First of all, you need to make sure you have SQL Server running on your workstation. Open up your services window in control panel. Look for MSSQLServer. If it exists and is started, you have SQL Server installed. This may be why your machine is not listed in the target list of the copy database wizard.
How large is the database you want to copy? Once you have SQL Server installed on your workstation, I would restore the latest backup of the DB that you want to copy to your local SQL Server. Reference backup/restore operations in BOL or in your book.
February 28, 2006 at 5:50 am
Just to further clarify the situation, no, having Enterprise Manager running locally is not the same as to have SQL Server installed and running on your machine. Enterprise Manager and Query Analyzer belong to "client tools" that you can install on any computer an then use them to access databases and installations of SQL Server on other machines. Follow John's instructions to find out, whether SQL Server is running on your PC; also, the icon of SQLS could be shown in the tray if SQLS is installed - and it should indicate whether it is running or stopped.
Most probably you will need to install SQL Server on your workstation... and then, as John suggested, take a backup of the DB and restore it there. Much better than any attempt to copy the file.
February 28, 2006 at 5:53 am
Great advice guys, and thanks for your patience with me. Should I install SQL Personal, or a ful copy of SQL Server?
Once again, thanks allot.
Dave
February 28, 2006 at 8:34 am
SQL Server 2000 Standard and Enterprise editions require a server operating system, so you cannot install either of those on Windows XP, for example. You'd have use the personal or developer version on a desktop operating system.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply