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...

how can you move the master database

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Why use sub query in sql server and list out types of sub queries?

1056


What is difference between sql and sql server?

1081


what's the maximum size of a row? : Sql server database administration

1164


How retrieve field names from the table in SQL through JAVA code?

1958


What is the fillfactor concept in indexes?

1036


Explain the first normal form(1nf)?

1078


What are key constraints?

1018


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2631


Explain syntax for disabling triggers?

1097


What is the user of Primary key?

1030


Explain query editor regions

1109


Explain about link server in sql server?

1116


How to include date and time values in sql statements?

1143


explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1152


How to create dbo table in sql server?

1005