322 reputation
110
bio website
location United Kingdom
age
visits member for 4 years, 8 months
seen Dec 15 at 0:13

Email: stackoverflowmartinsmith@gmail.com


Feb
2
comment How can Windows defragmentation tools cause internal fragmentation in SQL Server?
I understand why the Windows disc defragmenter doesn't fix internal fragmentation. My question was as to how it could actually cause it?
Feb
2
asked How can Windows defragmentation tools cause internal fragmentation in SQL Server?
Feb
2
comment Recover SQL Server 2008 database
What method were you using to do the copy? Was it the detach/reattach method? Also what error do you get if you try and reattach it? If you weren't using detach/reattach to copy then did you detach it yourself somehow? Even if the service restarts unexpectedly it should just continue recovery and rollback any uncommitted transactions on restart.
Jan
11
comment Need help recovering a corrupt SQL database
The GAM and SGAM are at known fixed locations aren't they?
Sep
18
awarded  Commentator
Sep
17
comment SQL Server - What ports to open on firewall to get access
Belongs on Server Fault. Is this default or named instance?
Sep
10
comment Hacked by Black Jaguar
@Keith - Now it's been migrated I think you literally can!
Aug
9
awarded  Editor
Aug
9
revised SQL 2008 R2: How to determine who restored the database?
added 80 characters in body
Aug
9
answered SQL 2008 R2: How to determine who restored the database?
Jul
15
answered Error in connecting SQL Server
Jul
14
comment sql server: cannot open backup device
You should be able to see the account that SQL Server is running under by opening the services applet (Start -> run -> services.msc -> OK). I'd create a dedicated Folder - e.g. C:\Backups rather than giving it permissions on the root of the drive though. It should be straightforward but if not you can use Process Monitor technet.microsoft.com/en-us/sysinternals/bb896645.aspx to see any ACCESS DENIED errors and the account that is denied access.
Jul
14
comment sql server: cannot open backup device
Through Windows Explorer but obviously that would increase the surface area for escalation if any vulnerabilities exist in SQL Server or your code. Where is the instance? Is it installed on your machine or do you access it across a network?
Jul
14
answered sql server: cannot open backup device
Jul
4
awarded  Supporter
Jul
3
comment sql 2008 express into cluster
So what's the setup for your software? How many clients do you have connecting to the database? If it does crash is it a major problem if the secondary database is not completely up-to-date?
Jul
3
comment sql 2008 express into cluster
But probably belongs on server fault...
Jul
3
comment sql 2008 express into cluster
@senzacionale Perhaps update your question with what exactly you need it to do.
Jul
3
answered sql 2008 express into cluster
May
7
answered WWW or no WWW - WHERE DO I CONFIGURE THIS?