Back-up on access file
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=23064
Printed Date: 28 March 2026 at 11:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Back-up on access file
Posted By: mrg1
Subject: Back-up on access file
Date Posted: 06 April 2007 at 1:48am
|
Yesterday I had to change hosting provider... At that time, the best option for back up was to save all data from mssql server with DTS tool. Everything went just fine, but the nightmare started soon after, on my attempt to recreate database on new sql server...
It is impossibile... I've tried several approaches: I created db structure with mssql_database_setup.asp and then to insert data... Failure... I tried to insert data with DTS and then recreate with SQL Manager indices, rels, defaults, etc... Failure again... Pls help... I'm dying... 
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 06 April 2007 at 8:02am
|
If possible I find the best way to move an SQL Server database is to ask your host to make a back file of it and send it to you, and then ask your new host to attach the backup file to your SQL Server database.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: mrg1
Date Posted: 06 April 2007 at 9:34am
| Funny thing, I've moved between resellers of same hosting service. Let's say I missed the opportunity... No other way? PLS... |