Restoring.............

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.
-ErlandEasiest in the login run is to read about the RESTORE command in Books Onlin
e. 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
>|||Tibor Karaszi wrote:
> Easiest in the login run is to read about the RESTORE command in Books Onl
ine. After you understand
> how that RESTORE command work, you will find it natural how to work the GU
I dialog in Enterprise
> Manager (if you chose to use it instead of executing the RESTORE command i
n Query Analyzer).
>
osql
restore database blah from disk = 'c:\blah.dat'
something like that

restoring sql to another server

What are the step to restore sql database to another server
FYI: I have sql2000 server
I want to restore the database from sql-server to old-server
thanksAssuming you have a full backup of database on sql-server machine:
1) copy the backup file to old-server
2) run the restore database from EM or QA and change the location of files
accordingly
3) run sp_changedbowner if required
OR
if u just want to move copy of database to another machine:
1) detach the database on sql-server
2) copy the data and log files to old-server
3) attach the files to both sql-server and old-server
"frank" wrote:
> What are the step to restore sql database to another server
> FYI: I have sql2000 server
> I want to restore the database from sql-server to old-server
> thanks
>|||http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"frank" <frank@.discussions.microsoft.com> wrote in message
news:8623F485-A988-48D6-86AD-056E41CC132D@.microsoft.com...
> What are the step to restore sql database to another server
> FYI: I have sql2000 server
> I want to restore the database from sql-server to old-server
> thanks
>

restoring sql to another server

What are the step to restore sql database to another server
FYI: I have sql2000 server
I want to restore the database from sql-server to old-server
thanksAssuming you have a full backup of database on sql-server machine:
1) copy the backup file to old-server
2) run the restore database from EM or QA and change the location of files
accordingly
3) run sp_changedbowner if required
OR
if u just want to move copy of database to another machine:
1) detach the database on sql-server
2) copy the data and log files to old-server
3) attach the files to both sql-server and old-server
"frank" wrote:

> What are the step to restore sql database to another server
> FYI: I have sql2000 server
> I want to restore the database from sql-server to old-server
> thanks
>|||http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"frank" <frank@.discussions.microsoft.com> wrote in message
news:8623F485-A988-48D6-86AD-056E41CC132D@.microsoft.com...
> What are the step to restore sql database to another server
> FYI: I have sql2000 server
> I want to restore the database from sql-server to old-server
> thanks
>

restoring sql to another server

What are the step to restore sql database to another server
FYI: I have sql2000 server
I want to restore the database from sql-server to old-server
thanks
Assuming you have a full backup of database on sql-server machine:
1) copy the backup file to old-server
2) run the restore database from EM or QA and change the location of files
accordingly
3) run sp_changedbowner if required
OR
if u just want to move copy of database to another machine:
1) detach the database on sql-server
2) copy the data and log files to old-server
3) attach the files to both sql-server and old-server
"frank" wrote:

> What are the step to restore sql database to another server
> FYI: I have sql2000 server
> I want to restore the database from sql-server to old-server
> thanks
>
|||http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"frank" <frank@.discussions.microsoft.com> wrote in message
news:8623F485-A988-48D6-86AD-056E41CC132D@.microsoft.com...
> What are the step to restore sql database to another server
> FYI: I have sql2000 server
> I want to restore the database from sql-server to old-server
> thanks
>
sql