Connexeon Blog » Blog Archive » T-SQL to attach database

T-SQL to attach database

July 4, 2008 – 15:19 by Hannes Van de Vel

Attach a db to SQL Server 2005 using this T-SQL statement;

sp_attach_db @dbname = 'yourdb',
@filename1 = 
'C:\Program Files\SWsoft\Plesk\Databases\MSSQLEXPRESS\MSSQL.1\MSSQL\Data\yourdb_Data.MDF'

	BLOG HOME \| About us \| Partners \| Customers Home News Opinion Labs Sysadmin T-SQL to attach database July 4, 2008 – 15:19 by Hannes Van de Vel Attach a db to SQL Server 2005 using this T-SQL statement; sp_attach_db @dbname = 'yourdb', @filename1 = 'C:\Program Files\SWsoft\Plesk\Databases\MSSQLEXPRESS\MSSQL.1\MSSQL\Data\yourdb_Data.MDF' Post a Comment Name (required) E-mail (will not be published) (required) Website Social