Viewing 15 posts - 27,661 through 27,675 (of 49,552 total)
Stefan Krzywicki (2/18/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 1:53 pm
Stefan Krzywicki (2/18/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 1:45 pm
Almost certainly not.
If (and only if) the database was in full recovery and the log had never been truncated since the last full backup and the database was still listed...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 12:51 pm
Stefan Krzywicki (2/18/2011)
As far as "touch base" goes, doesn't Cricket have bases as well?
No. It has stumps and bails, wickets and creases. The ball has to hit the wicket (and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 12:38 pm
HowardW (2/18/2011)
If you're in any way bothered about it, the only way to do this is to host the database internally and provide the service rather than the software.
And...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 12:37 pm
parthi-1705 (2/18/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 12:33 pm
From object explorer, attach database, select the files, give it a new name, click ok.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 12:31 pm
sdffdfad faadffad (2/18/2011)
Stopping thieves this way is not ideal, I do agree, but it is better than let them steal your work.
I'm sorry, but unless you're written the T-SQL equivalent...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 9:29 am
To what end?
You cripple any ability to maintain the code, you hinder performance and for what?
If the code must be completely confidential, host the SQL server. Otherwise put copyright and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 9:10 am
Doesn't matter what the app is written in, unless it was designed to be able to handle data spread across two databases it won't be able to and it will...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 8:10 am
george sibbald (2/18/2011)
It obviously can be recreated but new database corrupts every time, so we have an underlying problem.
A fairly serious one I would say. May I suggest putting the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 7:57 am
At what point?
I've done exactly what I told you to do, so I know it does work.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 7:02 am
Yes yuo can. Look up ALTER DATABASE in books online, you can use that to change the phycial names that SQL knows, then take the DB offline, move the files...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 7:00 am
george sibbald (2/18/2011)
Have a good day (I'm not!)
No backups? :hehe:
Be sure to check the system, raid, SAN logs. Something did this, you don't want it to happen again and worse.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 6:58 am
CLR is not a way. It's trivial to decompile CLR.
If you give your clients a database, you cannot stop them from reading the code in the stored procedures. Don't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2011 at 6:55 am
Viewing 15 posts - 27,661 through 27,675 (of 49,552 total)