1,007 reputation
617
bio website linkedin.com/in/briandknight
location Glen Allen, VA
age 37
visits member for 4 years, 10 months
seen Dec 18 at 19:26

I am a database and emerging technology expert, focusing on new trends and technologies in the world of software. I develop computing platform architecture solutions using cloud-computing and high-scale data platforms.


Mar
10
comment SQL Server stops regularly on every windows restart
Looking at your last error log - it says that NetworkService is unable to open a specified database. Your service account should have master set as it's default database. I am wondering if it is set to a different database that has not yet gone through startup recovery some of the time. Ensure the default database is master.
Mar
9
comment Domain Change, Lost Access to SQLEXPRESS
@ColdT sure - that would work also. Either way, the change in the domain of his account is the culprit. More than one way to skin the cat.
Mar
9
answered SQL Server stops regularly on every windows restart
Mar
9
answered Domain Change, Lost Access to SQLEXPRESS
Feb
17
awarded  Yearling
Jan
14
comment mongod autostart
Are you running MongoDB on Linux or Windows? Both can be setup to start on reboot, but the process is different.
Jan
14
answered Filegroup cannot be removed because it is not empty error with no files
Sep
23
awarded  Popular Question
May
23
accepted RDP client error using Cisco SSL VPN
May
18
revised RDP client error using Cisco SSL VPN
edited tags
May
18
asked RDP client error using Cisco SSL VPN
Mar
8
answered SSMS 2008 - Can't Add Maintenance Plans
Mar
7
answered WMI Notfication and database mirroring
Feb
18
awarded  Yearling
Jan
21
answered Patching New Node on SQL Server 2005 /Windows 2003
Jan
21
awarded  Critic
Oct
20
comment How large can the undo file grow to?
It's a little tricky to get it to go into STANDBY only at certain times. You could stop the log shipping restores for a period, run a script to restore WITH STANDBY, crunch numbers, and then rollback the UNDO file. If that's too much trouble, I'd just recommend restoring with STANDBY as part of the log shipping restore.
Oct
20
answered How large can the undo file grow to?
Oct
4
awarded  Tumbleweed
Aug
26
answered Can I use the export/import data in SQL 2008 with FK constrained tables?