Viewing 15 posts - 796 through 810 (of 1,179 total)
Again it depends on how critical the data is and you need to justify taking differential backup.
In your environment taking differential backup will only help when you need to recover...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 8, 2010 at 2:34 am
Run the "Alter Index" command "with SORT_IN_TEMPDB = ON"
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 29, 2010 at 12:11 am
Ganga,
I agreed with Mohammed Sort in tempdb option will use space of tempdb your tempdb will grow 🙂 to restrict the logfile growth during maintenance.
set Tlog to perform every 10...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 21, 2010 at 11:00 pm
Mine is wrong too! mdf 3 MB + LDF 1 MB = 4 MB for SQL 2005 EE.
Question should be more accurate but anyway I enjoy all this discussion 😛
Cheers!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 21, 2010 at 10:17 pm
First of all check if the Database Mail is enabled in surface area configuration.
Second, check SMTP Server is configured correctly and prot 25 is open as default it's communicating to...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 21, 2010 at 12:36 am
Looks like your database is not of production as you are trying to delete the database; if so you can put the database into single user mode with no wait...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 20, 2010 at 1:57 am
I doubt if it's possible for result pan 🙁
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 19, 2010 at 11:39 pm
check this out I have picked from the yesterday thready:
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 4, 2010 at 11:29 pm
is it possible to post the result of sys.dm_db_physical_index(null,null,null,null,null) so that we can have closuer look.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 4, 2010 at 10:46 pm
I also go wrong...
I also think that there are only two instances. But actually it’s Total 3 instance including default.
If we think logically nothing should be affected. But I still...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 31, 2009 at 12:07 am
Log file size of 4 MB is very normal compare to total db size 133 GB. Even if log file size is 4 GB due to typo mistake It is...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 24, 2009 at 4:35 am
What is the size of the Database?
What is the size of Data and Log files?
Size of the Tlog depends on the nature of the application and what activities are running...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 24, 2009 at 3:25 am
I beg your pardon. It's not UPDATE STATISTICS it's DBCC UPDATEUSAGE. Run UPDATEUSAGE before SHRINKDATABASE OR SHIRNKFILE.
"DBCC UPDATEUSAGE corrects the rows, used pages, reserved pages, leaf pages and data page...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 23, 2009 at 10:50 pm
Can you check if UPDATE STATISTICS help?
Just guessing...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 23, 2009 at 4:58 am
Also it's depends on the size of the Database too. If the database is too large than re-orgeanize will be helpful so that there will not be any blocking etc....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 22, 2009 at 6:14 am
Viewing 15 posts - 796 through 810 (of 1,179 total)