Viewing 15 posts - 3,601 through 3,615 (of 7,499 total)
did you try this in SSMS:
EXEC sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO
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
July 5, 2009 at 3:04 am
With clustering stuff, many thing must be managed using cluster administrator!
What are you looking for ? (With regards to instance management)
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
July 4, 2009 at 1:59 am
GilaMonster (7/2/2009)
ALZDBA (7/2/2009)
Keep prod and dev data on separate instances !Keep prod and dev on different servers!
Whenever possible indeed !
OP stated
..dev server is gng to decomission soon ..
I...
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
July 3, 2009 at 8:00 am
That is strange indeed.
Double check if you are trying to move the correct db-files. (they can have any name with no "link" to the db itself)
Check if there are still...
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
July 3, 2009 at 12:51 am
I'm totally with Lynn here :w00t:
One other thought of the day:
Whay are you defining the clustering index on a 3-column ix ?
- Are those columns always used (all 3...
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
July 2, 2009 at 12:42 pm
I'm with PaulB's suggestion !
Keep prod and dev data on separate instances !
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
July 2, 2009 at 12:31 pm
it may need some time to actually take it offline.
It will no longer accept new connections/commands for that db.
But it may need to complete the offload, taking some time.
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
July 2, 2009 at 12:28 pm
Maybe just create a view (on the remote server) and query that.
Test it and see what the effects are.
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
July 2, 2009 at 12:45 am
Marcus Wilkinson (6/30/2009)
All my jobs todate have been owned by the same service account that has local admin rights.
Ok, to comfirm, now I'm using a proxy and a different...
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
July 1, 2009 at 4:52 am
hi_abhay78 (6/30/2009)
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
July 1, 2009 at 4:47 am
get rid of the linked server !
Why: query stability !
Keep in mind if sqlserver cannot find a "by default" good plan, it may pull over all data of the...
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
June 30, 2009 at 12:38 pm
This is actually thé weak spot of SQLAgent. :crying:
What I do is create a SQL user account, make that account jobowner of the jobs non-sysadmins are wanting to manage.
Also add...
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
June 30, 2009 at 12:32 pm
For the moment, add the service account you are using to the windows local administrators group of your server.
Maybe best to stop / start your sqlinstance.
Then you should be able...
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
June 30, 2009 at 12:04 pm
Chris,
I just hope people don't get scared to start small, if you hit them with "armagedon" :hehe:
Don't present a dam breakage scenario for those that need to seal up a...
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
June 30, 2009 at 7:37 am
check you sqlserver instance ERRORLOG file to see if the startup is OK.
You may also want to try to add your windows account to the local server group called
computername\SQLServer2005MSSQLUser$computername$instance
In my...
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
June 30, 2009 at 3:35 am
Viewing 15 posts - 3,601 through 3,615 (of 7,499 total)