Re: Losing default settings it table fields after database restore
- From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 19 Dec 2006 20:43:51 +0000
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:48CB45ED-039B-4177-BD0B-745647DE690A@xxxxxxxxxxxxx:
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.
.
- Prev by Date: Re: Dynamic setting of Destination in Data Transformation Task
- Next by Date: Re: SSIS: something is seriously wrong
- Previous by thread: Re: Referencing a ssis system variable in a script task
- Next by thread: Re: converting data to null using DBNull problem
- Index(es):
Relevant Pages
|
