Re: changing db location on sql2000

I think I'll stick to righ clicking for now. That works, I managed to copy the database I need moved. Do you know how to change the default location it saves new databases?

Kevin3NF wrote:
Right click the datbase, all tasks, detach database. Move the files to D. Right click "Databases", all tasks, attach database

Or you can do the same things with sp_detach_db and sp_attach_db if you are happier in code

.

Relevant Pages

  • Re: What is an OODBMS?
    ... passed to a search engine. ... pointers, I'd be much happier. ... the database and have it return a list of matching objects I'd be much ... >> to separate the application from the persistence layer. ...
    (comp.object)
  • Re: VSS 800423f4 error after Sharepoint backup test
    ... instructions to delete the STS_RESTORE database! ... SBS Backup failing if you don't do this deletion (or the instructions ... >Enterprise Manager and then the recovery model can be changed to Simple. ... On the Attach Database page, ...
    (microsoft.public.windows.server.sbs)
  • System.Data.SqlClient.SqlException: CREATE DATABASE
    ... I was able to resolve the below issue. ... >CREATE DATABASE permission denied in database 'master'. ... >Could not attach database 'Contacts' to ...
    (microsoft.public.cert.exam.mcad)
  • System.Data.SqlClient.SqlException: CREATE DATABASE
    ... CREATE DATABASE permission denied in database 'master'. ... Could not attach database 'Contacts' to ... execution of the current web request. ...
    (microsoft.public.cert.exam.mcad)
  • Unable to attach the database
    ... the hole disk space. ... No I am trying to attach database, however I am not able to do so. ... Device activation error. ...
    (comp.databases.ms-sqlserver)
Loading