Hello,
I'm not a DBA (obviously!) and want to perform what I suspect is a fairly
easy task. However, I'm having troble finding how to do it.
I want to move a database off of one SQL 7 server and onto another existing
SQL 7 server. How can I go about doing this?
Thanks for your help, it's very much appreciated!
BHave a look at these. While some may be specific to 2000 it should note when
it is.
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
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"Brian" <bhanley72@.yahoo.com> wrote in message
news:OPGr1az$EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm not a DBA (obviously!) and want to perform what I suspect is a fairly
> easy task. However, I'm having troble finding how to do it.
> I want to move a database off of one SQL 7 server and onto another
> existing
> SQL 7 server. How can I go about doing this?
> Thanks for your help, it's very much appreciated!
> B
>
Showing posts with label obviously. Show all posts
Showing posts with label obviously. Show all posts
Monday, March 12, 2012
Move SQL 7 DB to Another SQL 7 Server
Hello,
I'm not a DBA (obviously!) and want to perform what I suspect is a fairly
easy task. However, I'm having troble finding how to do it.
I want to move a database off of one SQL 7 server and onto another existing
SQL 7 server. How can I go about doing this?
Thanks for your help, it's very much appreciated!
B
Have a look at these. While some may be specific to 2000 it should note when
it is.
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
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"Brian" <bhanley72@.yahoo.com> wrote in message
news:OPGr1az$EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm not a DBA (obviously!) and want to perform what I suspect is a fairly
> easy task. However, I'm having troble finding how to do it.
> I want to move a database off of one SQL 7 server and onto another
> existing
> SQL 7 server. How can I go about doing this?
> Thanks for your help, it's very much appreciated!
> B
>
I'm not a DBA (obviously!) and want to perform what I suspect is a fairly
easy task. However, I'm having troble finding how to do it.
I want to move a database off of one SQL 7 server and onto another existing
SQL 7 server. How can I go about doing this?
Thanks for your help, it's very much appreciated!
B
Have a look at these. While some may be specific to 2000 it should note when
it is.
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
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"Brian" <bhanley72@.yahoo.com> wrote in message
news:OPGr1az$EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm not a DBA (obviously!) and want to perform what I suspect is a fairly
> easy task. However, I'm having troble finding how to do it.
> I want to move a database off of one SQL 7 server and onto another
> existing
> SQL 7 server. How can I go about doing this?
> Thanks for your help, it's very much appreciated!
> B
>
Move SQL 7 DB to Another SQL 7 Server
Hello,
I'm not a DBA (obviously!) and want to perform what I suspect is a fairly
easy task. However, I'm having troble finding how to do it.
I want to move a database off of one SQL 7 server and onto another existing
SQL 7 server. How can I go about doing this?
Thanks for your help, it's very much appreciated!
BHave a look at these. While some may be specific to 2000 it should note when
it is.
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
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"Brian" <bhanley72@.yahoo.com> wrote in message
news:OPGr1az$EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm not a DBA (obviously!) and want to perform what I suspect is a fairly
> easy task. However, I'm having troble finding how to do it.
> I want to move a database off of one SQL 7 server and onto another
> existing
> SQL 7 server. How can I go about doing this?
> Thanks for your help, it's very much appreciated!
> B
>
I'm not a DBA (obviously!) and want to perform what I suspect is a fairly
easy task. However, I'm having troble finding how to do it.
I want to move a database off of one SQL 7 server and onto another existing
SQL 7 server. How can I go about doing this?
Thanks for your help, it's very much appreciated!
BHave a look at these. While some may be specific to 2000 it should note when
it is.
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
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"Brian" <bhanley72@.yahoo.com> wrote in message
news:OPGr1az$EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm not a DBA (obviously!) and want to perform what I suspect is a fairly
> easy task. However, I'm having troble finding how to do it.
> I want to move a database off of one SQL 7 server and onto another
> existing
> SQL 7 server. How can I go about doing this?
> Thanks for your help, it's very much appreciated!
> B
>
Subscribe to:
Posts (Atom)