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 |
|
nanaz
Starting Member
3 Posts |
 Posted - 2011-06-27 : 20:49:32
|
| I was unable to view page. I have checked in Microsoft SQL Server Management Studio Express, no database that using for the page. So I need to attach the database. It has happened every day since last week. I am using SQL Express 2005.Please advise. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-06-27 : 20:54:14
|
quote:
I was unable to view page
can you explain what do you mean by "unable to view page" ?quote:
no database that using for the page
What page is that ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
nanaz
Starting Member
3 Posts |
Posted - 2011-06-27 : 21:04:07
|
quote:
Originally posted by khtan
quote:
I was unable to view page
quote:
can you explain what do you mean by "unable to view page" ?
If no database, the selected page will be direct to homepage. For example, if I want to view page "Tender Notice", then it be directly to homepage, because database that call in the page cannot found. Then after reattach the missing database, the page can be viewed.quote:
no database that using for the page
quote:
What page is that ?
asp.net page
KH[spoiler]Time is always against us[/spoiler]
quote:
quote:
|
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-06-27 : 21:18:36
|
check the SQL Server log on any detached activity on the database.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
nanaz
Starting Member
3 Posts |
Posted - 2011-06-27 : 21:30:45
|
quote:
Originally posted by khtan
check the SQL Server log on any detached activity on the database.
KH[spoiler]Time is always against us[/spoiler]
I don't know to check. Can you checked it for me?You can download the log in the [url]http://www.mediafire.com/?amnxb4nc61o2s9g[/url] |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-06-27 : 22:14:58
|
Sorry, i can't access file hosting site from here. The SQL Server log that i refer to can be access easily via the Management Studio.From Management Studio, go to Management - SQL Server Logs. You should see a current & several Archive. click on it and see what is going on.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
|
|
why need to deattach the database