How long it will take? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

How long it will take?

Author

Topic

zhshqzyc
Posting Yak Master

240 Posts

Posted - 2011-11-15 : 15:33:42

Hello, I am running a script to create a database. The mdf file is about 180MB. How long it will take? Because it already passed 30 minutes, the status is still "debugging query".

USE [master]
 GO
 CREATE DATABASE [AdventureWorks2008] ON 
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\AdventureWorks2008R2_Data.mdf' ),
 ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\AdventureWorks2008R2_Log.ldf' ),
  FILEGROUP Documents CONTAINS FILESTREAM (NAME = Documents, FILENAME=N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\Documents')
  FOR ATTACH
 GO

Thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-11-15 : 16:00:45

Stop the query. You must have clicked the Debug button instead of run, so the query's in debug mode waiting for you to step over the statements.

Make sure you click run this time (or hit F5)

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources