|
Home > Archive > Microsoft SQL Server forum > November 2005 > [Newbie] Restoring.............
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
[Newbie] Restoring.............
|
|
| Erland 2005-11-17, 9:23 am |
| Hi,
I am very new to Microsoft Technologies, infact new to database world
:)I have a SQL-Server 7.0 back. How can i restore it? Moreover , can i
restore this backup by using SQL-Server 2000Enterprise edition, how
should i go about it?
Any help or comments will be highly appreciated.
-Erland
| |
| Tibor Karaszi 2005-11-17, 9:23 am |
| Easiest in the login run is to read about the RESTORE command in Books Online. After you understand
how that RESTORE command work, you will find it natural how to work the GUI dialog in Enterprise
Manager (if you chose to use it instead of executing the RESTORE command in Query Analyzer).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Erland" <Erland.Erikson@gmail.com> wrote in message
news:1132234090.437642.38470@f14g2000cwb.googlegroups.com...
> Hi,
> I am very new to Microsoft Technologies, infact new to database world
> :)I have a SQL-Server 7.0 back. How can i restore it? Moreover , can i
> restore this backup by using SQL-Server 2000Enterprise edition, how
> should i go about it?
> Any help or comments will be highly appreciated.
> -Erland
>
| |
| CONTROL 2005-11-24, 9:23 am |
| Tibor Karaszi wrote:
> Easiest in the login run is to read about the RESTORE command in Books Online. After you understand
> how that RESTORE command work, you will find it natural how to work the GUI dialog in Enterprise
> Manager (if you chose to use it instead of executing the RESTORE command in Query Analyzer).
>
osql
restore database blah from disk = 'c:\blah.dat'
something like that
|
|
|
|
|