SQL Server Performance

creating a database

Discussion in 'SQL Server 2005 General DBA Questions' started by priyaram, Jan 30, 2007.

  1. priyaram New Member

    suppose if we want to create a database and all it relative things to a new server , for that if we restore the backup copy of that databas in a new server will it create the database and restore the data.
    Is it enough to restore the backup copy or we need to restore the log also.
  2. dineshasanka Moderator

    restore the backup will do

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  3. madhuottapalam New Member

    If you restored the database in new server from a Full backup , you will have data and all other object in the restored database till the time of Full Backup taken. You restore Transaction Log backup only when you want to restore the database to a specific time. You need to read more about Backup Architecture of SQL Server in BOL.


    Madhu
  4. priyaram New Member

    for creating a newdatabase from existing backup in a new server, will the backup file (residing in some other server) need to be moved to the new server?
    because if i check for restore , it's only showing the drives located in the local server.
  5. Luis Martin Moderator

    quote:Originally posted by priyaram

    for creating a newdatabase from existing backup in a new server, will the backup file (residing in some other server) need to be moved to the new server?
    because if i check for restore , it's only showing the drives located in the local server.

    Yes you have to use the MOVE option in restore.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  6. Roji. P. Thomas New Member

    quote:Originally posted by priyaram

    for creating a newdatabase from existing backup in a new server, will the backup file (residing in some other server) need to be moved to the new server?
    because if i check for restore , it's only showing the drives located in the local server.

    No need to move the file. you can use a UNC path.

    Roji. P. Thomas
    SQL Server MVP
    http://toponewithties.blogspot.com
  7. Roji. P. Thomas New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by LuisMartin</i><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by priyaram</i><br /><br />for creating a newdatabase from existing backup in a new server, will the backup file (residing in some other server) need to be moved to the new server?<br />because if i check for restore , it's only showing the drives located in the local server.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Yes you have to use the MOVE option in restore.<br /><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">All in Love is Fair <br />Stevie Wonder<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />I guess its the translator, not Louis [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Roji. P. Thomas<br />SQL Server MVP<br /<a target="_blank" href=http://toponewithties.blogspot.com>http://toponewithties.blogspot.com</a><br />
  8. satya Moderator

    Yes you have to move the file the destination server and then use RESTORE wizard from there, as suggested by Luis you have to use that when using RESTORE statement from query analyzer.

    quote:Originally posted by priyaram

    for creating a newdatabase from existing backup in a new server, will the backup file (residing in some other server) need to be moved to the new server?
    because if i check for restore , it's only showing the drives located in the local server.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  9. priyaram New Member

    will the move option will actually move the file from one server to another server or it's make a copy of the file in the new server
  10. madhuottapalam New Member

    hi priyaram,

    what r u talking about... r u talking about .Bak (extension can be anything for that mater) file ie. Backup file ?

    Madhu
  11. satya Moderator

    WITH MOVE can only be called in RESTORE statement, that you have to carry out on a SQL Server (in this case on destination server).
    In any case if you are talking about database backup file then you have to copy the file to other server.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  12. Roji. P. Thomas New Member

    Confusion reigns! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Roji. P. Thomas<br />SQL Server MVP<br /<a target="_blank" href=http://toponewithties.blogspot.com>http://toponewithties.blogspot.com</a><br />
  13. Luis Martin Moderator

    I'm confused too.

    After Roji post I don't know if he want to restore from network or coping the backup to new server and then restore it.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  14. satya Moderator

    Its over 4 days now, so lets wait for Originator's reply [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]./<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</i></font id="size1"></font id="teal"></center>

Share This Page