clean database set for sql 2008 r2

[JohnsonSausage]

could anyone please upload a clean kal_auth and kal_db database set for sql 2008 r2 please ?

i was using sql 2000 and i didnt back up my database to a .bak before i formated my pc and went to windows 7 and sql 2008 r2.

i found this post on a forum that gave an option to attach an sql 2000 db using this method


USE master;
GO
CREATE DATABASE kal_db ON PRIMARY
(FILENAME =
'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\kal_db.mdf')
LOG ON (FILENAME =
'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\kal_db_log.ldf')
FOR ATTACH;
GO



USE master;
GO
CREATE DATABASE kal_auth ON PRIMARY
(FILENAME =
'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\kal_auth.mdf')
LOG ON (FILENAME =
'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\kal_auth_log.ldf')
FOR ATTACH;
GO



but before doing this i would rather just have a proper clean database set specific for sql 2008.

thank you in advance ...

 

[Darn]

there is a request section.
http://forum.ragezone.com/f241/kalonline-request-section-974540/


just rename the files to .bak and restore them.

You must be registered to see links

 

[JohnsonSausage]

there is a request section.
http://forum.ragezone.com/f241/kalonline-request-section-974540/


just rename the files to .bak and restore them.

You must be registered to see links

worked like a charm thank you sir