master database
-
Hi All,
Can anyone help me, I have backedup my master database lastweek, and now I want to restore it back now. Will there be any problem?
Anyone tell what is the core role of master database in sql server2000?
-
NO what hppened that I go and removed all the exteded stored procedure. After that I can not use most of the functions in my sql server eventhough I restored back all the extended stored procedure. before I removed the stored procedure I backedup master database.
So in order to fix this I have to restore the Master database
-
first of all : don't mess with master unless you know what you are doing
master keeps the inventory of databases, locations, users,....
It is _the_ most important systemsdatabase.
There is a msdn article wich describes "restoring master" :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4g4w.asp
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply