Viewing 15 posts - 9,016 through 9,030 (of 9,241 total)
search this site for some of Brad McGhee's tutorials, they're very helpful
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 1:40 am
as a side note BOL also recommends to update usages too using
dbcc updateusage
I've already seen a similar problem on a couple of databases i upgraded recently.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 1:36 am
glad you're all sorted 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2008 at 10:27 am
can only be done for adding columns as far as i know
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2008 at 8:26 am
Rod at work (7/17/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2008 at 7:59 am
you should always rename the server before SQL is installed.
Un install SQL server, rename the server then re install
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2008 at 2:11 am
virtual server enterprise will quite happily allow virtual sql servers to run, in fact it is possible to set up a 2 node sql cluster 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2008 at 4:36 pm
under 10 user connections!
i would home on an existing instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2008 at 10:05 am
have the backup verify the files at backup time. if storing on a backup on a network,
backup to local drive first then copy to network
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2008 at 10:02 am
when you attach\restore a db to SQL2005, i'm pretty sure it runs DBCC CHECKDB as part of the upgrade!
You would certainly be advised to update the stats to sql2005 stats
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2008 at 6:16 am
you can also use the alter database modify file command to move the files, make sure they're in the same location as MASTER as already stated
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2008 at 4:24 am
Junior_DBA (7/21/2008)
1) offline DB2) detach DB
for future reference;
once the database is marked offline you do not need to detach the database you can just go ahead and copy the files...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 11, 2008 at 4:36 am
go into Add\remove programs and select the .NET 2 framework. Run a repair of this first (click change\remove and it will ask to repair or remove)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 11, 2008 at 4:31 am
as mentioned the primary reason for filegroups is to spread the database across multiple disks\arrays to increase performance. Placing filegroups on the same array is really pointless
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2008 at 10:24 am
just out of interest why are you upgrading Windows 2003 std to 2003 Enterprise in the first place. I always prefer a clean install for NOS's
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2008 at 10:17 am
Viewing 15 posts - 9,016 through 9,030 (of 9,241 total)