Viewing 15 posts - 2,311 through 2,325 (of 7,502 total)
I would prepare a job for that and link that one to an alert.
All your test users have to do is raise the error and the restore job will get...
February 20, 2011 at 10:06 am
I always kick out sqlexpress whenever I need to install any other version of sqlserver.
SQLexpress is fine, but it may generate conflicts with the other versions during install, upgrade, hf,..
(during...
February 20, 2011 at 1:28 am
AFAIK no.
- what's the need for this to be in a sproc ?
- Can't you use a sqlagent job or a sqlcmd to perform the restore and other needed actions...
February 19, 2011 at 11:17 pm
You didn't attach the log files.
(best is to zip them and then attach to your reply)
February 19, 2011 at 11:11 pm
How about the "Intervention system for runaway jobs" : http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30713/
I haven't tested/modified it for SQL2008 features though.:blush:
February 19, 2011 at 1:02 pm
Roy Ernest (2/18/2011)
ALZDBA (2/18/2011)
Roy Ernest (2/18/2011)
...
I am in the Caribbeans.. The Dutch carribean. ...
Next time, at SQLPass, remind me of this trip , so we can have a little chat...
February 19, 2011 at 10:49 am
Koen Verbeeck (2/19/2011)
Roy Ernest (2/18/2011)
I am in the Caribbeans.. The Dutch carribean.Do they speak Dutch over there?
Didn't you hear the latest "Lotus speculoospasta" advertisement on the radio.
That's the kind...
February 19, 2011 at 10:33 am
I think most of us must be aliens :alien::alien::alien::alien: 😀
February 19, 2011 at 3:24 am
Roy Ernest (2/18/2011)
...
I am in the Caribbeans.. The Dutch carribean. ...
Next time, at SQLPass, remind me of this trip , so we can have a little chat in Dutch 😀
(...
February 18, 2011 at 2:14 pm
Stefan Krzywicki (2/18/2011)
...
He's got one comment that is really funny though where he responds to ALZDBA (who has excellent English) with
Ian is correct to himself not me because both of...
February 18, 2011 at 10:54 am
Ian Scarlett (2/18/2011)
Gianluca Sartori (2/18/2011)
Do you remember Lennie, the guy with sock-puppets friends?He's back again. Nothing worth worrying about, at the moment.
http://www.sqlservercentral.com/Forums/Topic1066085-9-1.aspx
And I was unfortunate to see this post AFTER...
February 18, 2011 at 2:51 am
Of course Ian is correct !
The problems lies with the dev who tries to fit header rows into his row set and doesn't know how to make his combobox show...
February 18, 2011 at 2:30 am
- Is there any other connection connected to your database ?
- is there any blocking going on for that database ?
February 17, 2011 at 12:10 pm
hydbadrose (2/15/2011)
... restore the TDE database on same server....
this is the obscure part ... I interpreted it as database name, not encryption related.
You can have more than one...
February 16, 2011 at 12:09 am
just keep in mind you cannot restore Ent edition backups to Std edtion if you are using Ent Edtn features ! (partitioning, ...)
February 15, 2011 at 10:50 am
Viewing 15 posts - 2,311 through 2,325 (of 7,502 total)