Viewing 15 posts - 8,506 through 8,520 (of 9,244 total)
malcolmwatt (1/18/2009)
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2009 at 10:07 am
how did you get on?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 11:22 am
he was probably looking for something along the lines of
sql server stores data on disk in pages which are 8Kb in size. 8 pages make up one extent and these...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 10:51 am
as well as the version get the following
select @@servername, serverproperty('servername')
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 10:45 am
it seems you have 2 instances referencing COW0, my guess is you upgraded the wrong one hence why you see the sql2000 version number. Are the 2 extra instances MSDE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 10:31 am
yes just seen the COW0 instance in the registry too. Scroll across to the right on the right hand pane, what are the installed instances?
what instance name are you typing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 10:28 am
so besides the 2 default desktop engines you have an instance
MSSQL$COW0, what instance are you logging into via SSMS?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 10:23 am
Todd Engen (1/8/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 9:35 am
presumably you have access to the source for the CLR functions you are to migrate?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 7:36 am
kiransuram19 (1/16/2009)
I took backup of the customterDB(using Litespeed) and the .bak file size is 15.6MB..
what compression were you using within Litespeed?
on a database that contains a lot of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 4:49 am
SBS installs 2 desktop engine instances. One for Sharepoint and one for SBSMonitoring.
Can you post a registry screenshot of the following key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 4:27 am
RPSql (1/12/2009)
I have one issue..I have server A and Server B. Now on Server B my sql server agent is disabled. I have setup a maintenance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 3:46 am
check your column data types, growing 8GB in 3 years doesnt seem too wrong depending on the data you are storing
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2009 at 3:39 pm
piece of advice, dont screw with MSDB if you must backup the database first.
apart from that, 335 MB isnt too bad but i noticed the job history table is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2009 at 3:25 pm
Tracey
remember the path for the resource db data and log file must be the same as the master.mdf
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2009 at 11:01 am
Viewing 15 posts - 8,506 through 8,520 (of 9,244 total)