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.
| Author |
Topic |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2008-03-31 : 14:17:44
|
| Select into query that ran for several hours failed and table got truncated ... what might be the reasons? In the db I have two datafiles... with unrestricted growth and the space allocalted are13834 MB and 12576 MB. What can be the problem?one of the sql server logs were:Autogrow of file 'filename2' in database 'dbname' cancelled or timed out after 4094 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-03-31 : 14:40:58
|
perhaps the autogrow failed because there is no space left on the disk?
elsasoft.org |
 |
|
|
GhantaBro
Posting Yak Master
215 Posts |
Posted - 2008-03-31 : 14:46:17
|
| so when we create a db and use the drive that enough space, do we have to mention the space allocated or should we leave what is in default.... ???i am going to create new db with data files in dfferent drives that has spaces and do the same with log file... thanks! |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-03-31 : 17:22:02
|
| Auto-growing a database can have an impact on performance. If you have a general idea as to how big it's going to be after inserting the data, size it up right away.Terry |
|
|
|
|
|
|
Scheduled job failed