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 |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2008-05-16 : 12:47:02
|
| Gurus,When I am in Maintenance mode, The users are trying to hit the database. I want to throw some message when they are trying to hit the database while it is in maintenance mode!! Is it possible..?If possible, please help me to solve my problem.ThanksKrishna |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-16 : 13:17:03
|
| what do you mean by Maintenance Mode? What are you trying to achieve? |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-05-16 : 13:18:54
|
| Backup or Restore-- Krishna |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-16 : 13:23:03
|
| Why does it matter during backups or restores? Backups are online operations. You shouldn't need to be in a specific downtime window for backups. For restores, the users can't successfully make it into the database until the restore is complete.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-05-16 : 13:26:11
|
| I just asking for specific time. Not for daily routines. Some times we used to restore the copy of production database to test server. For that purpose only i am asking to create a alert. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-16 : 15:57:24
|
| Since you are restoring to other server (Test) Why are you worried? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-17 : 17:35:04
|
| You can just send out message to tell people will restore db soon. |
|
|
|
|
|
|
Message in Maintenance mode