|
Posted by Tim on 03/08/06 15:59
Thanks for the assistance! It's been very helpful.
Tim
DickChristoph wrote:
> Hi Tim
>
> Why don't you ask them to run a backup of the database(s) in question to a
> file and then restore the databases on your end. If the SQL Server 2005
> developer version has a Enterprise Manager this is pretty easy to do. If not
> read Books Online about the Restore Command.
>
> BTW I don't know if you can attach an MDF that hasn't been previously
> detached (using sp_detach_db). Your customers almost certainly won't want to
> detach their open databases just to send them to you, whereas a full backup
> can be run on a open database. I suspect just doing a Copy of an open MDF
> may give you a file you can't use in any way.
>
> See books online about sp_attach_db and sp_detach_db and my favorite
> sp_attach_single_file_db (which attaches an MDF without needing the LDF).
>
> For Example:
>
> EXEC sp_attach_single_file_db @dbname = 'pubs',
> @physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
>
> You might try this with the file(s) you have and see if if works.
>
Navigation:
[Reply to this message]
|