|
You need to develop a sense of humour and read earlier threads, ass hat.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
if it had data in it then restore from backup.
As barmey as a sack of badgers
|
|
|
|
|
You can't per se, the data is gone.
However as Simon said you can restore from the last backup. S??? happens, that's what backups are for.
If this is a production DB on the otherhand, s??? should rarely happen to them, which means an awfull lot of arselicking would be required.
If there are no backups, divert blame to the DBA as s??? happens and that's what backups should be for.
If you are the DBA, and no backups have been performed, and this was the dev environment, copy the production environment to dev.
If you are the DBA, and no backups have been performed, and this was the production environment find the nearest exit and polish your resume.
Good luck!
|
|
|
|
|
Sorry I did not see this sooner, so this is too late.
Depending on your disaster recovery model you could do a point in time restore from your backup. This would mean you need full recovery mode, and using the transaction logs.
|
|
|
|
|
If this is production AND you have a backup, you may not want to restore over the top of a production database. you can instead restore to a new database, then add the column allowing nulls, use an update query to put the data back leaving anything in the other columns unchanged. depends on the nature of your data and environment.
|
|
|
|
|
hi guys
when i was tring to restor my db
i faced with this error
"the execution permission was denied on the object sp_enum_sqlagent_subsystems,database msdb,schema dbo-error 229"
please help, my job is in danger
i use sql server 2008
|
|
|
|
|
|
didi you know you are so cute and funny?
ha!ha
|
|
|
|
|
And? That's the first thing you do with an error message if you don't understand it.
|
|
|
|
|
haha that is sweet man! I didnt know that website existed.
|
|
|
|
|
|
This may help.[^]
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
or this[^]
Phil
The opinions expressed in this post are not necessarily those of the author, especially if you find them impolite, inaccurate or inflammatory.
|
|
|
|
|
moein.serpico wrote: "the execution permission was denied on the object sp_enum_sqlagent_subsystems,database msdb,schema dbo-error 229"
By default, members of the sysadmin fixed server role can execute this stored procedure. Other users must be granted the SQLAgentOperatorRole fixed database role in the msdb database.
I are Troll
|
|
|
|
|
Hello,
I have a desktop software developed with VB.NET using Ms Access as backend. I want some security measuremetns vis which the data remains safe and secure - others or employees can't open or view the contents of the data.
How can I achieve the same ?
Any helpline, guidance is highly appreciative.
Thanks & Regards,
|
|
|
|
|
|
That is for sure. But their are also some who can crack the password. Thinking for protection from that prospect, I think should have somethign more solid also maybe along with password protection.
Thanks & Regards,
|
|
|
|
|
Then you can't use an Access database. You'd have to use SQL Server for better protection.
|
|
|
|
|
You should keep the password encrypted in the configuration file for increased security. Still, as Dave said, if you have sensitive data in it, then go for SQL. You can make use of SQL express edition since that is free hence will not charge you more money.
|
|
|
|
|
|
I had read about encrypting the DB, but for usage as a backend will have to decrypt each time I use the DB via application and the applicatio nwill be running almost the whole day. Encrypting & Decrypting huge db often is not a good idea according to me.
What do you think ?
Thanks & Regards,
|
|
|
|
|
As per your clarification, I think you are right.
Thanks
Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
Access is a bad production database because it is so open. Can you use SQL Express or some other for the back end?
Note when you use a password on Access you open a new set of problems.
|
|
|
|
|
If it's not possible to use SQL Server as others have suggested, you can always encrypt data that's being written into the DB, where the encryption library will be in your application. But it's not fool proof, and it'll mightily slow down all data access.
SG
Aham Brahmasmi!
|
|
|
|
|
I am onto a project of backoffice management of International stock exchanges. I need to manage trades of different stock exchanges there. The date and time I am getting from exchange is according to their time zone. Further I need to calculate some thing using their time. Some of reports I need to generate after converting the time to my time zone that is IST (I am from India).
Now what I have in my mind is to store the time provided by the exchange with the time zone (of the exchange) and also the converted (to IST) time.
I am looking for some idea how to store the time zone and the converted time into database.
Is there any facility in SQL server to time between time zones or I have to keep the time gap between zones?
I have found
SQL 2005 Time Zone Conversion Functions[^]
and
http://msdn.microsoft.com/en-us/library/ms145276%28SQL.90%29.aspx[^]
But, what would be the best practice to do such thing?
|
|
|
|