Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how can you move the master database

Question Posted / rushi


how can you move the master database..

Answer / sreekanth

Need to do changes in the Startup Parameters
If you want to move your files you need to remove the
current entry and recreate your new entry with the correct
path. For example, To move the Master database log to
C:\test\. First delete the -l [path] by highlighting the
old parameter and choosing remove. Add the following entry,-
l C:\test\mastlog.ldf and click OK twice. Now, you will
stop SQL Server and move the mastlog.ldf to its new
location.

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is self join in sql server joins?

0 Answers  

how you can list all the tables in a database?

0 Answers  

What is the cpu pressure?

0 Answers  

What is a trigger? Why we need it?

0 Answers   Accenture,

last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

What are filegroups in sql server?

0 Answers  

What is fill factor and pad index?

0 Answers  

What are subqueries in sql server?

0 Answers  

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

What is a self join in sql server?

0 Answers  

How do you identify a foreign key?

0 Answers  

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

For more SQL Server Interview Questions Click Here
Categories