> Does anyone know of a way to rebuild the database from the
> previous SQLDatabase file? I have still got the original
> data files, but the reloaded SQL7 won't recognise them.
>
> As far as I've found, the SQL Server 7 documentation only
> tells me how to import a SQL database from a backup, not
> from a data file.
You can use sp_attach_db to add your old database file to your new SQL
Server 7 install:
EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\mssql7\data\pubs.mdf',
@filename2 = N'c:\mssql7\data\pubs_log.ldf'
(from SQL Server Books Online)
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
