Viewing 15 posts - 391 through 405 (of 972 total)
The only thing I would think might be the culprit could be the dbo schema. When a user is created in SQL 2005 and later it will be assigned the...
March 31, 2011 at 1:07 pm
Check the installation log of the service pack and see if it shows any error messages.
:w00t: shows what happen when you skim over something instead of reading it in detail!
March 29, 2011 at 10:32 am
SQL Nexus[/url] is a nice tool to use to process trace files.
ClearTrace is another one: http://www.scalesql.com/cleartrace/%5B/url%5D
March 18, 2011 at 11:42 am
where you drives that the databases resided on, paritcular tempdb on a SAN that was connected through the switch?
Can you get to the tempdb log file itself on the server?
March 18, 2011 at 10:19 am
grryshhy (2/21/2011)
March 16, 2011 at 10:56 am
If you want to backup selected databases, you would need to put a check beside each one you want to backup.
As suggested though if you want all the user databases,...
March 15, 2011 at 10:11 am
It was a good article. I have not read all the comments but has anyone mentioned that you reference images, but I did not see them in the article?
March 11, 2011 at 7:52 am
You can probably setup a perfmon log and begin capturing information on how SQL Server and the OS is performing. SQLServerPedia.com has some good videos on using perfmon and focus...
March 7, 2011 at 12:27 pm
Once you get a chance this is a good video/script to check out from Brent Ozar that can help you get an idea of what you are looking at regarding...
March 7, 2011 at 12:01 pm
Take it a piece at a time...The first piece you need to look at is the backups of the database. Ensure you have some and that they are good (meaning...
March 7, 2011 at 11:59 am
If you go by this you will not see a service pack for SQL 2008 R2 until 12-months from the RTM release.
Which it was released in May 2010 so...
March 4, 2011 at 2:17 pm
In-case you ever do get PowerShell in use PowerShell.com posted a tip today for the one-liner command to use:
Determining Service Start Mode
Shows you how to query WMI through PowerShell to...
March 2, 2011 at 8:36 am
DBA328 (2/24/2011)
It seems the back compression only aviliable in enterprize edition.
Starting with SQL Server 2008 R2 Standard Edition, backup compression is available.
February 24, 2011 at 7:26 am
gemisigo (2/22/2011)UPDATE!!!
I've found a mouse in the trap! Someone was trying to alter accesses to some catalogs and it implicitly resulted in an "EXEC sys.sp_configure N'allow updates', N'1'".
I made...
February 24, 2011 at 7:21 am
Viewing 15 posts - 391 through 405 (of 972 total)