Re: question -- copy database?
From: fred rosenberg (info)
Date: 08/31/04
- Next message: UncleSam89: "Re: DTS csv import fails when using double quotes as the Text Qual"
- Previous message: David E Herbst: "Re: DTS csv import fails when using double quotes as the Text Qualifie"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 31 Aug 2004 09:08:01 -0500
Thank you Andrew!
Fred
"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:O1bGBTwjEHA.3968@TK2MSFTNGP11.phx.gbl...
> The short answer is no. You can use sp_attach_db in a similar fashion
> though. These links will get you going:
>
>
> http://www.support.microsoft.com/?id=224071 Moving SQL Server
Databases
> to a New Location with Detach/Attach
>
> http://www.support.microsoft.com/?id=314546 Moving DB's between
Servers
> 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
>
>
> "fred rosenberg" <info at osagecomputing dot com> wrote in message
> news:uFFVvNwjEHA.3664@TK2MSFTNGP11.phx.gbl...
> > hi,
> >
> > first, i apologize if this is not quite the correct newsgroup for this
> > question (feel free to point me to another one.)
> >
> > I notice that databases seem to be stored in: C:\Program
Files\Microsoft
> > SQL Server\MSSQL\Data -- in two files, an MDF and an LDF. basic
question.
> > can i just copy these two files to another machine, and stick them in
the
> SS
> > directory for that machine, and have SS recognize the database?
> >
> > thanks,
> >
> > fred
> >
> >
>
>
- Next message: UncleSam89: "Re: DTS csv import fails when using double quotes as the Text Qual"
- Previous message: David E Herbst: "Re: DTS csv import fails when using double quotes as the Text Qualifie"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
