Viewing 15 posts - 2,311 through 2,325 (of 7,499 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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 19, 2011 at 10:33 am
I think most of us must be aliens :alien::alien::alien::alien: 😀
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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 😀
(...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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 ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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, ...)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 15, 2011 at 10:50 am
Viewing 15 posts - 2,311 through 2,325 (of 7,499 total)