dbTalk Databases Forums  

Re: Losing default settings it table fields after database restore

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Re: Losing default settings it table fields after database restore

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Re: Losing default settings it table fields after database restore in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Losing default settings it table fields after database restore - 12-19-2006 , 02:43 PM






When you originally did your export using DTS did the defaults come
across? My guess is not. A BACKUP/RESTORE will take everything across
so I do not think it is here that things are getting lost.



--


Regards


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



"Roger Withnell" <RogerWithnell (AT) discussions (DOT) microsoft.com> wrote in
message news:48CB45ED-039B-4177-BD0B-745647DE690A (AT) microsoft (DOT) com:

Quote:
I backup my database daily from the operational server to a local server
using DTS to import from SQL Server to SQL Server (and then Backup
Database
to make a .bak file of the imported database).

When I had to restore the database recently using the reverse procedure
all
the default settings in the table fields were lost when the tables were
exported to the operational server.

Any help much appreciated.


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top