Viewing 15 posts - 241 through 255 (of 442 total)
GilaMonster (3/15/2013)
SQLCrazyCertified (3/15/2013)
I thought it should truncate the inactive logs after logbackup\shrink are done.
Just like any other database in full recovery, the logs are truncated (marked as reusable) when a...
March 15, 2013 at 3:18 pm
Lynn Pettis (3/15/2013)
March 15, 2013 at 2:53 pm
Sqlism (3/11/2013)
I mean to say any other driver other than C drive. I specified E drive as example. sorry for the confusion. So can someone conclude that...
March 11, 2013 at 7:27 pm
SQLCrazyCertified (3/11/2013)
Sqlism (3/11/2013)
Binaries from
OS binaries ?
My question is , is this is the best practice to change root directory from default...
March 11, 2013 at 1:57 pm
Sqlism (3/11/2013)
Binaries from
OS binaries ?
My question is , is this is the best practice to change root directory from default location...
March 11, 2013 at 1:48 pm
Normally, from my experience, SQL binaries goes to D: drive and separate data, log and temdb to different drives based on your environment standards.
SueTons.
March 11, 2013 at 1:32 pm
opc.three (3/1/2013)
Nah, see my last post.
Yea got it. I replied before I read your post.
Thanks again.
SueTons.
March 1, 2013 at 6:19 pm
opc.three (3/1/2013)
SELECT *
FROM new_name_of_master.sys.configurations
WHERE ...
March 1, 2013 at 5:51 pm
GilaMonster (2/28/2013)
February 28, 2013 at 1:30 pm
GilaMonster (2/28/2013)
From Books Online:Permissions
CHECKPOINT permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles, and are not transferable.
Thanks Gail, but this particular...
February 28, 2013 at 12:22 pm
Ausman,
Just changing the recovery model to simple does not truncate the log....I think it has to wait for the next checkpoint to happen.
Also, I have noticed that if you haven't...
February 21, 2013 at 1:05 pm
anthony.green (2/19/2013)
SQLCrazyCertified (2/19/2013)
mwagh (2/19/2013)
Thanks!! works in my case as i have a lot initially allocated space which was never touched.
Hi, sorry, I was not aware of this, anyway,...
February 19, 2013 at 5:17 am
mwagh (2/19/2013)
Thanks!! works in my case as i have a lot initially allocated space which was never touched.
Hi, sorry, I was not aware of this, anyway, with truncate...
February 19, 2013 at 5:13 am
mwagh (2/19/2013)
Hi,I wanted to shrink a data file with the truncate only clause.Will i require to rebuild my indexes?
Shrinking data file is not recommended as it will create fragmentation and...
February 19, 2013 at 2:36 am
Viewing 15 posts - 241 through 255 (of 442 total)