a beginner''s question
-
I've got a backup file from my friend's computer. there is no database on my computer. i mean; i've got that database through backup file. Now i'm not aware how to view that database in enterprise manager. can you help me?
in simple; how can i convert a backup file into data & Log files?
-
go to books online, and lookup restore (assuming this is actually a backup file, and not just a copy of the log and data files). BOL should have a good description of how to restore it using Enterprise Mgr.
-
If by 'I don't have the database on my computer' you mean you don't have any version of the SQL Server engine installed on your computer, you won't be able to do anything with the backup file. You'd have to, at least, download and install the free SQL Server 2005 Express version from Microsoft. The you could use the restore commands or the restore wizard in the management tool to restore the database.
And then again, I might be wrong ...
David Webb -
i've sql server 2000 (installed) on my computer. what i mean to say is "I've only backup file of a database and don't know how to attach it since i don't have mdf/LDF file of this database.
that is database i've is only in the form of backup file"
hope u understand my point of view now
simple is that "how can we restore database from backup file (if not have MDF/LDF of that database"?
-
Look at the database restore function in Enterprise Manager. You will find info on that in books on line (BOL). Just make sure you look at the options tab and make sure you are restoring to a valid physical path.
-
1. Put your backup file in the sql backup folder, usually:
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
2. In EM, right-click on Databases, then click New database... and give it a name
3. Right-click on your new database, click All Tasks ~ Restore database
4. Click: From Device; Select Devices; Add; then navigate to & and select your backup file
5. Click OK twice to get back to the "Restore database" dialog
6. Click the Options tab, and where it says "move to physical file name" adjust the path & name if necessary (it will default to the name it had on the other sql server).
7. Click the checkbox "Force restore over existing database"
8. Click OK
-
thanx;
it works!!!! 
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply