Re: changing db location on sql2000

Seems I have a new issue. Sql Server 2000 does not want to attach a database that resides on a network drive. I am using a 2TB network/usb drive and even plugged up via usb like I have it, the pc views it as a network drive. It will attach databases on a regular usb drive. Do either of you know of a way around this?

Kevin3NF wrote:
Thanks Ekrem. Every time I see that option, I forget about it. :)

.

Relevant Pages

  • Re: register database
    ... MSDE will not come up with normal tools graphical tools. ... This will go go to a sql prompt, there execute the sp_attach_db to attach ... This will attach the database to sql server. ...
    (microsoft.public.sqlserver.server)
  • Re: Split Mirror backup and restores
    ... Well the minute you attach the mdf and ldf files, ... to the native attach/detach within SQL Server ... We will using the flashsnap plugin to do full database ...
    (microsoft.public.sqlserver.server)
  • Re: visutal studio.net 2005 debugging question
    ... version to debug with a sql server 2000 database. ... My goal is to debug some t-sql commands. ... attach to a process and the process that I need to attach to is ...
    (microsoft.public.vsnet.debugging)
  • LOG Device Corrupted
    ... sp_attach_single_file_db to attach the DB device to new sql server. ... Could not open new database XXXX, ... I tested use another DB to detach and delete the log file, than attach it ...
    (microsoft.public.sqlserver.server)
  • Re: Having a problem attaching a database
    ... SQL Server Storage Engine Development ... > having trouble attaching the database to pull the required information. ... Select the database that I want to attach (renamed file in new ... Click OK and a message appears asking if I want to create an ldf file. ...
    (microsoft.public.sqlserver.server)