Michael K Campbell

less info
260 reputation
13
bio website sqlservervideos.com
location
age
visits member for 5 years, 2 months
seen May 2 at 22:31

Oct
8
awarded  Yearling
Feb
22
comment Diagnosing Microsoft SQL Server error 9001: The log for the database is not available
Correct. Memory Usage won't have anything to do with this - unless the memory was corrupt and just transferred on down to the disk. Either way, you should be seeing some other indications of IO problems in your event logs. Somewhere.
Feb
22
awarded  Critic
Sep
24
comment Programmatically Copy Database like SQL Server 2008 Copy Database Wizard
And once you do the BACKUP/RESTORE, just pay attention to the possibility of orphaned users. An overview of why (and how to deal with them) is here: sqlservervideos.com/video/copying-and-moving-sql-server-logins
Sep
24
answered Cannot Delete SQL Server Database via Command Line Executable
May
27
answered SQL Server Transaction log Backup Frequency
May
11
answered How to setup daily backups with ms sql server agent 2005
Apr
30
awarded  Teacher
Apr
30
comment In SQL Server, when should you split your PRIMARY Data FileGroup into secondary data files?
Yup... spot-on analysis of the benefits. The only thing I would add is that you can also frequently off-load indexes from heavily accessed tables to their own spindles/filegroups to boost async/read-ahead performance. I've done that in a few cases with some larger deployments and helped companies save tens of thousands of $$ in hardware costs that their SAN vendors swore they would need to obtain the throughput they wanted.
Apr
30
answered Cheap clustering for SQL server
Apr
30
answered How can I backup an SQL server (2000 and 2005) database?
Apr
30
awarded  Supporter
Sep
18
answered Backup SQL Server to a Network Share