I have an MS SQL 2000, which I use for development. I accidentaly deleted some files(I guess so) of the database,
Now I can't see some tables and stored procedures. Is there a away to replace it/ restore it to its original state? I am a newbie,
so please give me some tips?
Go to the directory c:\program files\microsoft sql server\mssql\install or wherever you installed SQL Server. There you will find a SQL script called instnwind.sql. This is a script that drops and recreates
This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed