Viewing 15 posts - 451 through 465 (of 501 total)
If you really want to change the owner you can modify it in msdb.sysdtspackages.
August 31, 2007 at 2:31 pm
This article also explains how to transfer the SID's along with the logins using a couple of stored procs.
August 31, 2007 at 12:10 pm
A mirrored db can be used as a reporting db when used with database snapshots. This may accomplish what you need.
August 17, 2007 at 5:01 pm
I would recommmend 4 drives for datafiles (one for each CPU core), 1 drive for your log files, and 1 drive for tempdb database. The link below is also handy.
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx
August 16, 2007 at 5:10 pm
The cost of the exam is $125 in the United States.
August 15, 2007 at 5:34 pm
My bet is the db was shrunk to leave no free space, set to auto grow at some interval around 100MB, and someone inserted some data causing the database...
August 14, 2007 at 4:54 pm
Set Category for the database to 0 in master.dbo.sysdatabases. Then you can delete it.
August 3, 2007 at 5:01 pm
Carl is correct. Change the maintenance plan to NOT shrink the database.
Make sure you have 1.2 times the largest table's free space in the data file to re-index the tables....
August 1, 2007 at 5:31 pm
After getting a little more info myself, it's supposed to be Unix time. The number of seconds since midnight UTC of January 1, 1970. Michael's solution works perfectly. Thanks.
July 18, 2007 at 9:36 am
Using Active Directory distribution groups is also handy. Then you can make the AD admins make the changes.
July 13, 2007 at 5:19 pm
RAID5 is not the way to go. See the below article on SQL Server Storage Best Paractices:
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx
July 11, 2007 at 5:19 pm
If there is only 3GB being used in a 12GB log file, you may be able to shrink the production log file using DBCC SHRINKFILE. Then do the backup and...
July 11, 2007 at 4:32 pm
Does the server need more memory? Have you ran perfomance counters (Target Server Memory)?
Currently you do not have the /3GB switch and have 16GB in the box. So, 2GB is...
June 28, 2007 at 5:21 pm
Sounds like a flaky network card. Try switching to a different NIC in the box to see if the issue remains.
June 27, 2007 at 4:51 pm
Viewing 15 posts - 451 through 465 (of 501 total)