1. Home
  2. Point-Of-Sale Software
  3. New Install Help

New Install Help

I have deployed MSDE on advance server 2000 and installed RMS, created new sample database and connected with RMS, Now the question is that my c drive has only 500 meg left and I would like to move the database on drive D to work with RMS. any suggestions??

Reply to
SA Baker
Loading thread data ...

An error occurred while executing query:

Line 2: Incorrect syntax near 'copy'.

"Kaib> execute following command in Administrator program:

Reply to
SA Baker

execute following command in Administrator program: exec sp_detach_db 'RMSSample', 'true' copy rmssample.mdf and rmssample.ldf to drive D exec sp_attach_db @dbname = N'RMSSample', @filename1 = N'D:\rmssample.mdf', @filename2 = N'D:\rmssample.ldf'

Reply to
Kaibin

I am sorry for the confusing.

  1. Run exec sp_detach_db 'RMSSample', 'true' in Admin program.
  2. Move your database files(RMSSample_Data.mdf and RMSSample_Log.ldf) to Drive D:, database files should be in 'C:\Program Files\Microsoft SQL Server\MSSQL\Data'
  3. Run exec sp_attach_db @dbname = N'RMSSample', @filename1 N'D:\rmssample_data.mdf', @filename2 = N'D:\rmssample_log.ldf'

Reply to
Kaibin

Thanks for the help, after the execution I got the msg below

Query executed successfully

-1 records (s) affected

do I need to do anything else or this should do it.

SA Baker

"Kaib> I am sorry for the confusing.

Reply to
SA Baker

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.