Restoring to another server issue with data file sizes

I'm using SQL Server 2000 and need to restore a large database onto a different node. The problem is the original database has a 74 gb first datafile and the node where I need to restore it doesn't have a single drive that big. I'm trying to use a backup of the original database and restore it into an existing database on another node and am using the move options to put the files in the right places.

Is there a way I run the restore to split the 74 gb datafile across drives on my target node?

Thanks for any help.Is there a way I run the restore to split the 74 gb datafile across drives on my target node?

I don't think so; you would have to do this first on the source database and then edit the file paths when restoring to the backup database.

Regards,

hmscott

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!
> >>
> >>
> >>
>
>

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 o
r
> not. So the answer is that there should be no problems related to the fac
t
> 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...
>
>|||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/feat...cle.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/col...se
s.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/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
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:F8C4F023-1F1E-4CF1-ACA0-6E0D0212C18C@.microsoft.com...[vbcol=seagreen]
> 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:
>|||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 restori
ng
> 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/feat...cle.php/3379901 Movin
g
> system DB's
> http://www.support.microsoft.com/?id=314546 Moving DB's between Server
s
> http://www.support.microsoft.com/?id=224071 Moving SQL Server Database
s
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.sqlservercentral.com/col...
ses.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 Permissi
on
> 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
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:F8C4F023-1F1E-4CF1-ACA0-6E0D0212C18C@.microsoft.com...
>
>

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...
>
>
|||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/featu...le.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/colu...rdatabases.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/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
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:F8C4F023-1F1E-4CF1-ACA0-6E0D0212C18C@.microsoft.com...[vbcol=seagreen]
> 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:
|||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/featu...le.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/colu...rdatabases.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/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
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:F8C4F023-1F1E-4CF1-ACA0-6E0D0212C18C@.microsoft.com...
>
>
sql