Viewing 15 posts - 8,941 through 8,955 (of 9,244 total)
the following will forcefully shrink the logfile, set recovery model to FULL first
--Forcefully Reducing the Size of the SQL Server Log File
--(These instructions are rooted in SQL Server 7, but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 3:28 pm
Waseem Jaleel (8/28/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 3:18 pm
yes, that is correct. The first 70% of the log is unused, the active portion (status of 2) would prevent the log from shrinking to a realistic size. What is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 2:58 pm
your original post above indicates you need to drop users who own views??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 2:29 pm
ang
what is the output of the following query run against your database?
DBCC LOGINFO
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 2:21 pm
why not change all the view ownerships using sp_changeobjectowner,
once done then drop the users 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 2:13 pm
if you want to find disk space used on a server you could try a WMI query to get the info required.
Alternatively try BGInfo utility from sysinternals
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 1:47 pm
ss1011 (8/28/2008)
we would basically drop in the two files after stopping the service.
its not quite as simple as that
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 6:49 am
do you mean
active\active
or
active\passive
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 6:35 am
Imke Cronje (8/28/2008)
File ID 4 of database ID 5 cannot be shrunk as it is either being shrunk by another process or is empty.
yes and this message is fairly descriptive,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 4:40 am
my guess is 1 of the filegroups is already empty.
check your filegroups to see which are in use!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 3:50 am
to clarify on Karl's point further
create a domain local security group in AD which is assigned to the resource (i.e. add to sql server security as a login).
Then create a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 3:30 am
how many files\filegroups does the database consist of?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 3:26 am
Adam Bean (8/27/2008)
Weird ... I'm a local admin ... I just got done installing 2k5 standard and SP2 ... SP2 went fine, except for this one piece.
what OS is the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2008 at 4:26 pm
select from sys.objects where the object_id
what does it return for this?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2008 at 1:31 pm
Viewing 15 posts - 8,941 through 8,955 (of 9,244 total)