Viewing 15 posts - 8,206 through 8,220 (of 9,244 total)
Perry Whittle (6/9/2009)
Extra indexes may have been created, more data now than you had previously??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2009 at 5:54 am
even so it probably shouldnt be necessary on a daily basis.
although its never failed previously remember the database will change. Extra indexes may have been created, more data now than...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2009 at 8:09 am
if you have the extra disk resources i personally would prefer a clean install to the cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2009 at 6:49 am
you upgrade you dont perform upgradation there is no such term.
if you did not upgrade the original sql2000 instance the only option you have now is to script the objects...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2009 at 6:44 am
is it absolutely necessary to rebuild indexes nightly, normally once a week should suffice
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2009 at 6:31 am
visual studio 2003 and visual studio 2005 should be able to live on the same machine
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2009 at 6:28 am
start by setting the recovery model to simple for this database
and then take a full database backup. This will truncate the log file
Shrink the file to the desired size, if...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 8, 2009 at 6:51 am
if you really need to move logs for the master,model and msdb then use the
alter database modify file command
Tempdb may also be moved but make sure not to touch...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2009 at 2:55 pm
look in sql config manager. Find the instance and on the protocols click TCP. Right click and select preoperties then scroll all the way down. Dynamically assigned port will be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2009 at 2:46 pm
GilaMonster (5/25/2009)
you'll get errors saying that the files are not accessible.
you'll also get this if you mistype the file and or path too.
Tip: If you do get this message...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 25, 2009 at 8:53 am
winston
just to re iterate
the MOVE is only used when restoring a backup. When moving a data file location via ALTER DATABASE use MODIFY FILE. You can issue the statement while...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 25, 2009 at 7:41 am
use a select script to generate an insert script for each row in the table and coupled with a create table script you have your table in portable format
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 25, 2009 at 7:29 am
SQL Noob (5/15/2009)
is there any benefit to setting up a dev/qa cluster?
as i said above, you can play to your hearts content without fear of retribution. Mojo pointed out the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2009 at 11:26 am
thank you for all the +ve comments, i just hope this is useful to you all somehow. Its great for testing and if you blow away the cluster you dont...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 15, 2009 at 10:29 am
thanks for your reply. The document does specify you should only use for test\educational purposes and that options such as VMWare HA make this redundant. Its more for people who...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 15, 2009 at 10:16 am
Viewing 15 posts - 8,206 through 8,220 (of 9,244 total)