> -----Original Message-----
> From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 10, 2001 10:55 AM
>
>
> I did my development in windows 98 with SQL Server. I have now windows 2000,
> with a clean install.
>
> How do I get the SQL Server database which I have backed up from the
> win98/SQL Server set up into the new win2000/SQL Server set up?
>
> I have put the backed up database in the SQL Backup folder but SQL Server
> does not see it. I have looked at using Data Transformation Services but
> none of the options seem to give me a way of accessing the backed up SQL
> Server database.
>
> I know there is an easy solution to this but I don't know it. Can anyone
> help me on this?
Yes - all you need to do is to do an SQL backup to a local disk (device in SQL
speak), copy it across to your new server, and do a SQL restore. This should
work flawlessly. I do it every day to maintain a warm standby SQL server, and to
check the integrity of the data and the backup.
BTW - SQL dumps compress by a factor of about 10 with winzip if you need to
reduce the file size for any reason, e.g. before FTP.
Adrian Cooper.
Adrian Cooper.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
