Viewing 15 posts - 3,571 through 3,585 (of 7,503 total)
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 ,...
July 19, 2009 at 10:07 am
Which one did you pick ?
- the ddl trigger ?
- least privileged ?
- both ?
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...
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
...
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...
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...
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...
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
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...
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...
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...
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...
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...
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...
July 15, 2009 at 1:36 am
Nice article !
This is a time saver !
Thank you for sharing the experience.
July 15, 2009 at 1:01 am
Viewing 15 posts - 3,571 through 3,585 (of 7,503 total)