Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Unanswered: How to Rename the database device

    Hi,
    Sybase V12.0.0.1
    WinNT.

    I have added the db device name without .dat extension on our stand by system. and it is causing problem when I restore backup from the Live system which contain the device name as prod05.dat. So i need to rename the device name to prod05.dat.
    How can I do this please?

    Thanks, Gunas.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Please explain your problem in more detail.
    Device names should not cause any problems during a database load.
    The don't have to be named the same or even be of exact same size.
    As long as the overall sizes match what you see from
    select * from sysusages where dbid=<yourdbid> order by lstart

  3. #3
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Thanks

    Thanks, You are right. The restore is working now.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •