Restoring SQL 6.5 DBs

Hi
I am trying to restore several databases to a single server due to restricti
ons on hardware. Each server had previously had a database that was named ex
actly the same on each server. Therefore, the new instances will be appended
with an appropriate suffix
to distinguish it from the already existing database on the server.
The problem is actually trying to restore the first database. I have created
a new database and named it accordingly. I have a backup of the database I
want to restore to this server. When I try and restore it by entering the pa
th of the .dat file, the 'r
estore now' option is not highlighted.
Can anyone help point me in the right direction.
Many thanks
KalpeshHi Kalpesh,
Not sure what happend with Enterprise manager. The "Restore Now" button will
be enabled only after you
select the destination database , "Add file" button , and select the
correct backup file to restore and click "close".
(Now the Restore Now button will be enabled)...
ISQL_W
--
Why dont you try executing the below command to restore the database from
ISQL_W .
LOAD Database <dbname> from disk='C:\backup\dbname.DMP' with stats=10
(Do the same step for all the databases)
Note:
1. Change the file name and directory based on your requirement.
2. Ensure that SQL 6.5 is patched with SP5a + SP5a Post update
Thanks
Hari
MCDBA
"Kalpesh" <kalpeshvaghela@.eu.spherion.com> wrote in message
news:F1798555-BB00-435F-A9E2-AE546950EAFF@.microsoft.com...
> Hi
> I am trying to restore several databases to a single server due to
restrictions on hardware. Each server had previously had a database that was
named exactly the same on each server. Therefore, the new instances will be
appended with an appropriate suffix to distinguish it from the already
existing database on the server.
> The problem is actually trying to restore the first database. I have
created a new database and named it accordingly. I have a backup of the
database I want to restore to this server. When I try and restore it by
entering the path of the .dat file, the 'restore now' option is not
highlighted.
> Can anyone help point me in the right direction.
> Many thanks
> Kalpesh

Restoring SQL 6.5 DBs

H
I am trying to restore several databases to a single server due to restrictions on hardware. Each server had previously had a database that was named exactly the same on each server. Therefore, the new instances will be appended with an appropriate suffix to distinguish it from the already existing database on the server
The problem is actually trying to restore the first database. I have created a new database and named it accordingly. I have a backup of the database I want to restore to this server. When I try and restore it by entering the path of the .dat file, the 'restore now' option is not highlighted
Can anyone help point me in the right direction
Many thank
KalpeshHi Kalpesh,
Not sure what happend with Enterprise manager. The "Restore Now" button will
be enabled only after you
select the destination database , "Add file" button , and select the
correct backup file to restore and click "close".
(Now the Restore Now button will be enabled)...
ISQL_W
--
Why dont you try executing the below command to restore the database from
ISQL_W .
LOAD Database <dbname> from disk='C:\backup\dbname.DMP' with stats=10
(Do the same step for all the databases)
Note:
1. Change the file name and directory based on your requirement.
2. Ensure that SQL 6.5 is patched with SP5a + SP5a Post update
Thanks
Hari
MCDBA
"Kalpesh" <kalpeshvaghela@.eu.spherion.com> wrote in message
news:F1798555-BB00-435F-A9E2-AE546950EAFF@.microsoft.com...
> Hi
> I am trying to restore several databases to a single server due to
restrictions on hardware. Each server had previously had a database that was
named exactly the same on each server. Therefore, the new instances will be
appended with an appropriate suffix to distinguish it from the already
existing database on the server.
> The problem is actually trying to restore the first database. I have
created a new database and named it accordingly. I have a backup of the
database I want to restore to this server. When I try and restore it by
entering the path of the .dat file, the 'restore now' option is not
highlighted.
> Can anyone help point me in the right direction.
> Many thanks
> Kalpesh

Restoring SQL 6.5 DBs

Hi
I am trying to restore several databases to a single server due to restrictions on hardware. Each server had previously had a database that was named exactly the same on each server. Therefore, the new instances will be appended with an appropriate suffix
to distinguish it from the already existing database on the server.
The problem is actually trying to restore the first database. I have created a new database and named it accordingly. I have a backup of the database I want to restore to this server. When I try and restore it by entering the path of the .dat file, the 'r
estore now' option is not highlighted.
Can anyone help point me in the right direction.
Many thanks
Kalpesh
Hi Kalpesh,
Not sure what happend with Enterprise manager. The "Restore Now" button will
be enabled only after you
select the destination database , "Add file" button , and select the
correct backup file to restore and click "close".
(Now the Restore Now button will be enabled)...
ISQL_W
Why dont you try executing the below command to restore the database from
ISQL_W .
LOAD Database <dbname> from disk='C:\backup\dbname.DMP' with stats=10
(Do the same step for all the databases)
Note:
1. Change the file name and directory based on your requirement.
2. Ensure that SQL 6.5 is patched with SP5a + SP5a Post update
Thanks
Hari
MCDBA
"Kalpesh" <kalpeshvaghela@.eu.spherion.com> wrote in message
news:F1798555-BB00-435F-A9E2-AE546950EAFF@.microsoft.com...
> Hi
> I am trying to restore several databases to a single server due to
restrictions on hardware. Each server had previously had a database that was
named exactly the same on each server. Therefore, the new instances will be
appended with an appropriate suffix to distinguish it from the already
existing database on the server.
> The problem is actually trying to restore the first database. I have
created a new database and named it accordingly. I have a backup of the
database I want to restore to this server. When I try and restore it by
entering the path of the .dat file, the 'restore now' option is not
highlighted.
> Can anyone help point me in the right direction.
> Many thanks
> Kalpesh

Restoring SQL 2000 Database from Cluster Config to Standalone

Hi
I have a tech question relating to SQL 2000
If I had a 2 node cluster of SQL , are there any implications/restrictions
in restoring the Database to another Domain / Server which is a SINGLE non
clustered server?
Many thanks!The database knows nothing of if it is or ever was in a clustered server or
not. So the answer is that there should be no problems related to the fact
it was in a clustered server when the backup was taken.
--
Andrew J. Kelly SQL MVP
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:10C5AB6D-125C-4023-8018-52D126CACFA8@.microsoft.com...
> Hi
> I have a tech question relating to SQL 2000
> If I had a 2 node cluster of SQL , are there any implications/restrictions
> in restoring the Database to another Domain / Server which is a SINGLE non
> clustered server?
> Many thanks!|||So the domain also will not matter?...SQL will function if I was to restore
it on a Server that was in another WOrkgroup and not even a domain; like the
original?
"Andrew J. Kelly" wrote:
> The database knows nothing of if it is or ever was in a clustered server or
> not. So the answer is that there should be no problems related to the fact
> it was in a clustered server when the backup was taken.
> --
> Andrew J. Kelly SQL MVP
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:10C5AB6D-125C-4023-8018-52D126CACFA8@.microsoft.com...
> > Hi
> >
> > I have a tech question relating to SQL 2000
> >
> > If I had a 2 node cluster of SQL , are there any implications/restrictions
> > in restoring the Database to another Domain / Server which is a SINGLE non
> > clustered server?
> >
> > Many thanks!
>
>|||Again the database itself knows nothing of these things. The SQL Server
instance that you restore the db to has to deal with the OS and such. I
assume you already have that working since all you asked about was restoring
a db to another server. You may have to deal with a Login to db User
mismatch depending on the conditions but that may be true even if you
restored it on the same server. See if these help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's
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.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp
Moving Users
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
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:F8C4F023-1F1E-4CF1-ACA0-6E0D0212C18C@.microsoft.com...
> So the domain also will not matter?...SQL will function if I was to
> restore
> it on a Server that was in another WOrkgroup and not even a domain; like
> the
> original?
> "Andrew J. Kelly" wrote:
>> The database knows nothing of if it is or ever was in a clustered server
>> or
>> not. So the answer is that there should be no problems related to the
>> fact
>> it was in a clustered server when the backup was taken.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Jay" <Jay@.discussions.microsoft.com> wrote in message
>> news:10C5AB6D-125C-4023-8018-52D126CACFA8@.microsoft.com...
>> > Hi
>> >
>> > I have a tech question relating to SQL 2000
>> >
>> > If I had a 2 node cluster of SQL , are there any
>> > implications/restrictions
>> > in restoring the Database to another Domain / Server which is a SINGLE
>> > non
>> > clustered server?
>> >
>> > Many thanks!
>>|||Many thanks Andrew! Appreciate the response!
"Andrew J. Kelly" wrote:
> Again the database itself knows nothing of these things. The SQL Server
> instance that you restore the db to has to deal with the OS and such. I
> assume you already have that working since all you asked about was restoring
> a db to another server. You may have to deal with a Login to db User
> mismatch depending on the conditions but that may be true even if you
> restored it on the same server. See if these help:
>
> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
> http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
> system DB's
> 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.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp
> Moving Users
> 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
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:F8C4F023-1F1E-4CF1-ACA0-6E0D0212C18C@.microsoft.com...
> > So the domain also will not matter?...SQL will function if I was to
> > restore
> > it on a Server that was in another WOrkgroup and not even a domain; like
> > the
> > original?
> >
> > "Andrew J. Kelly" wrote:
> >
> >> The database knows nothing of if it is or ever was in a clustered server
> >> or
> >> not. So the answer is that there should be no problems related to the
> >> fact
> >> it was in a clustered server when the backup was taken.
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >>
> >> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> >> news:10C5AB6D-125C-4023-8018-52D126CACFA8@.microsoft.com...
> >> > Hi
> >> >
> >> > I have a tech question relating to SQL 2000
> >> >
> >> > If I had a 2 node cluster of SQL , are there any
> >> > implications/restrictions
> >> > in restoring the Database to another Domain / Server which is a SINGLE
> >> > non
> >> > clustered server?
> >> >
> >> > Many thanks!
> >>
> >>
> >>
>
>