Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Create database using Backup file Expand / Collapse
Author
Message
Posted Tuesday, November 18, 2008 6:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:16 PM
Points: 146, Visits: 459
Hi,

I have backup file of database in my local disk. I want to create a that database in another SQL Server. How can I do that?

Please send the steps to create the database using backup file?


Thanks a lot,
Venki
Post #604315
Posted Tuesday, November 18, 2008 8:23 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 27, 2014 7:59 AM
Points: 177, Visits: 757
Hi Venki,

You just have to do a RESTORE of the backup on the other server. Let's say the name of your backup file is "myBackup.bak" and you copy it to the root of c:.

First off, you need to find the logical names of the files:

RESTORE FILELISTONLY FROM DISK = 'c:\myDB.bak'

Make a not of the LogicalName for both datafile and logfile (let's say it's myDB_Data and myDB_log).

Next you RESTORE the database with the WITH MOVE clause so you can specify where on the second server you want to put the database.

RESTORE DATABASE myDB
FROM DISK = 'C:\myDB.bak'
WITH MOVE 'myDB_Data' TO 'C:\DATA\myDB.mdf',
MOVE 'myDB_Log' TO 'C:\DATA\myDB_log.mdf'
GO

HTH!

/Elisabeth


elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
Post #604439
Posted Tuesday, November 18, 2008 4:59 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 6,752, Visits: 14,400
venki

you can of course also use the management studio if you prefer GUI interraction


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #604760
Posted Wednesday, November 19, 2008 7:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:16 PM
Points: 146, Visits: 459
Perry Whittle (11/18/2008)
venki

you can of course also use the management studio if you prefer GUI interraction


How can we do with SQL Server Management Studio?


Thanks a lot,
Venki
Post #605147
Posted Wednesday, November 19, 2008 7:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
venki (11/19/2008)
Perry Whittle (11/18/2008)
venki

you can of course also use the management studio if you prefer GUI interraction


How can we do with SQL Server Management Studio?


Right Click on databases node on SSMS.

Click Restore Databases..
Post #605151
Posted Thursday, November 20, 2008 6:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:16 PM
Points: 146, Visits: 459
Thanks a lot to all of you for your suggestions.
I know how to create new databases. But I was first affraid when I got this requirement that I have to transfer the databases from one SQL Server to another SQL Server. I asked the DBA and he sent the back up files and he don't have the access to the other Server. so I did it successfully using SSMS.


Thanks a lot,
Venki
Post #605728
Posted Friday, January 9, 2009 5:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:16 PM
Points: 146, Visits: 459
steveb (11/19/2008)
venki (11/19/2008)
Perry Whittle (11/18/2008)
venki

you can of course also use the management studio if you prefer GUI interraction


How can we do with SQL Server Management Studio?


Right Click on databases node on SSMS.

Click Restore Databases..


After resotre databases, it is showing the present databases list in Databases combo box and how can I give the new name?


Thanks a lot,
Venki
Post #633266
Posted Friday, January 9, 2009 5:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 6,752, Visits: 14,400
click in the combo box and type a new database name ;)

if you right click at the "databases" node of the tree view the combo box should be empty when the restore window appears.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #633279
Posted Monday, March 16, 2009 7:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:16 PM
Points: 146, Visits: 459
I am getting the following error while doing restore operation through SSMS.

Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE HEADER ONLY is terminating abnormally (Microsoft SQL Server, Error: 3205)


In net, I found that this is due to the version problem i.e. the back up file is from SQL Server 2005 and My development Server is 2000. So the above error is coming. In microsoft site, they mentioned that to fix the problem, we have to upgrade the SQL Server Service Pack to latest Service Pack. In some other site, They mentioned that you have to upgrade your SQL Server 2000 to SQL server 2005/2008.

Now my question is that, is it not possible to restore through any commands(not with SSMS) like RESTORE DATABASE...etc?
If there is a way please tell me? What happens if I install the SPs? will they delete the data and upgrade the SQL Server to another SP? Basically I am a developer and I don't know much about restores and creation of DBs. So kindly help me please?


Thanks a lot,
Venki
Post #676449
Posted Tuesday, March 17, 2009 2:44 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
You cannot restore a SQL Server 2005 database backup to SQL Server 2000.



Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #677264
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse