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 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply