creating a database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

creating a database

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.
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/

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

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.
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.
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

<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 />
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.
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
hi priyaram, what r u talking about… r u talking about .Bak (extension can be anything for that mater) file ie. Backup file ? Madhu
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.
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 />
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.
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>
]]>