Viewing 15 posts - 3,571 through 3,585 (of 7,503 total)
Indeed, but the uncleanly "detached" files will only be a part of the problems.
Everything performed a instance level , logins, jobs, end points, instance level triggers, ... will have to...
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 19, 2009 at 11:10 am
You need to check on the rename server procedure !
SQLServer knows its own name, so you need to remove the old and add the new one.
http://msdn.microsoft.com/en-us/library/ms143799.aspx
stand alone instance
sp_dropserver
GO
sp_addserver ,...
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 19, 2009 at 10:07 am
Which one did you pick ?
- the ddl trigger ?
- least privileged ?
- both ?
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 18, 2009 at 8:54 am
16% free. but it represents 16GB.
How big is your biggest table (ix included if they reside in that datafile) ?
Why ? if you rebuild that table, you may need...
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 17, 2009 at 2:03 pm
Please post in the correct forum !
Search SSC for mirroring and it will come op with the script you need !
IMO best is to use SQLServer events for this !
e.g.
http://msdn.microsoft.com/en-us/library/ms191502%28SQL.90%29.aspx
...
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 17, 2009 at 10:46 am
PaulB (7/16/2009)
Juan Pablo (7/16/2009)
Try to put the sa account like owner of the job 🙂:blink: why would you nuke them when an infantry brigade would suffice?
hmm ... so the windows...
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 17, 2009 at 10:43 am
Cathy DePaolo (7/17/2009)
ALZDBA (7/17/2009)
It is indeed something you need to know about when trying to handle the files.BOL has good info at http://msdn.microsoft.com/en-us/library/ms178037%28SQL.90%29.aspx
ALZDBA, I paid more attention to the virtual...
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 17, 2009 at 6:57 am
- You did a good assessment of your options.
- As you know, clustering is mainly to overcome hardware failures.
The big advantage is that it is addressable using 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
July 17, 2009 at 6:20 am
It is indeed something you need to know about when trying to handle the files.
BOL has good info at http://msdn.microsoft.com/en-us/library/ms178037%28SQL.90%29.aspx
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 17, 2009 at 5:57 am
shrinking a log file will not move log data !
A log file can only be shrunk to the last active virtual log !
Hence, you may have to execute the shrink...
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 16, 2009 at 11:35 pm
Whenever I move sqlserver files, I always xcopy the current folders (without files) to the new location including the authorisations !
(/O parameter)
I'm sure ROBOCOPY will also have such an option.
You...
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 15, 2009 at 1:24 pm
- You can expect the log file to be as big as the data file, depending on how "intelligent" your perform index rebuilds.
- If someone performed massive updates, e.g. implemented...
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 15, 2009 at 1:18 pm
- sys.configurations is the source system object for sp_configure.
It is a system object, so where it gets it data from shouldn't matter.
(you can nolonger update catalog tables directly)
- AFAIK 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
July 15, 2009 at 1:08 pm
Best is to work with minimal rights.
So go for the solution provided by K. Brian Kelley !
But as a little safeguard, you could implement a database trigger to only allow...
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 15, 2009 at 2:05 am
Have you run dbcc checkdb lately ?
I always use shrinkfile in stead of shrinkdb.
(what are the sizes of your db files)
Keep in mind your shrink operation will perform heavy...
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 15, 2009 at 1:36 am
Viewing 15 posts - 3,571 through 3,585 (of 7,503 total)