Re: transfering database contents

Hi,

I think you might get the problem because of the folder structure.. Try using WITH MOVE parameter in restore command to restore the physical files to the correct path. Consider you have the database files in C:\Data in the production server and if you restore the database backup in development using the command below then you need to make sure C:\Data folder exists in development server or else use WITH MOVE parameter in restore command to restore the files to different path in development.

RESTORE DATABASE dbname FROM DISK='BACKUP PATH'

As Mark said please post the error message so that we can help you better.

Thanks,
Vidhya Sagar

"Mark Han[MSFT]" <v-fathan@xxxxxxxxxxxxxxxxxxxx> wrote in message news:9zHLI5ipJHA.5168@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi JRL,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that you would like to migrate the
membership database from the product server to the development server
If I have misunderstood, please let me know.

in order to address your concern, I would like to explain the following
1 Backup/restore is the suggested method to migrate a database. Based on
your description, I know that you meet an issue when restoring the backup
file on develop server. So please post the error message, I will try to
help to fix the issue.

2 Besides, we know you try to import data from produce server into develop
database. it is also a way to migrate the database. However it seems that
you meet an connection issue. So, if it is convenient to you, please post
the error message, too.

please try to use copy wizard to copy the database from produce server to
the development server to check if this way will work.

Based on my experience, this kind of issue might be a little complex. I
need to collect more information to diagnose the issue. So if it is
convenient to you, please send me an email and then I will create a
workspace for you to upload the required files.

My email address is v-fathan@xxxxxxxxxxxxxxxxxxxx(remove online)

Note, I will alo public our troubleshooting steps in the email.

I look forward to hearing from you.

Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx

============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

.

Relevant Pages

  • Re: Problem with disable msde connection pool
    ... 'ALTER DATABASE TestDB SET single_user WITH ROLLBACK after 10 ... ' Restart the server... ... ' Execute query through SQLDMO to run the restore TSQL command ... the connection pool must be disabled. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Restore public folders and companyweb
    ... I understand that the Public Folder Store ... > database cannot be mounted due to integrity problems, ... > the pub.edb database from your backup of the old Server, ... please try the following steps to restore your public ...
    (microsoft.public.windows.server.sbs)
  • WSUS Errors after System state restored
    ... recover sufficiently and the server went off whilst running. ... no avail and in the end just restored system state from the backup. ... Connection to database failed. ... see Help and Support Center at ...
    (microsoft.public.windows.server.sbs)
  • RE: Restore public folders and companyweb
    ... The new server must have the same domain name as the original server ... where the backup of the database. ... For the detailed steps to restore the SharePoint Services databases, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)