Registered users    
MembershipMembership:
Latest New UserLatest:James Johnson
New TodayNew Today:12
New YesterdayNew Yesterday:13
User CountOverall:23319
Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12890
Marina Roos12507
Eriq Neale2114
Stan Guinn1913
Michael Patrick1912
Robert Pearman1770
Nick Pieters1425
Stewart Brown616
william warren593
Kevin D.579
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000
Subject: move a sql db to a different server in a different domain
Prev Next
You are not authorized to post a reply.

Author Messages
ryan heiser User is Offline
United Kingdom
Member since
1/17/2006

Registered Users
Posts: 48
1/24/2006 03:06 PM  
How do I copy a sql Database to a new server on a new domain ?
Can I just detach the database copy the mdf and ldf files and re attach the databases on the new server ?
 
Kind regards
 
Ryan
Des Quinn User is Offline
United Kingdom
Member since
5/20/2005

Registered Users
Posts: 281
1/26/2006 01:31 AM  
why not do a backup and restore
ryan heiser User is Offline
United Kingdom
Member since
1/17/2006

Registered Users
Posts: 48
2/08/2006 12:28 PM  
I ended up detaching it and re connecting it on the new server 
Recreate the user account and voila
It all works
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > move a sql db to a different server in a different domain


ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.
Copyright 2002-2008 Concentrix b.v.    :   Page generated in 0.2968769 seconds.   :   Terms Of Use   :   Privacy Statement