Interested to Buy Any Domain ? << Click Here >> for more details...
how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server.
- 6 Answers
- 10407 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harish sharma
Sysdatabase table is the part of master database.
So u need to change the location of master database in this
case. which can be don in the database properties ->
statring parameters. Then u have to change the location of
all three files. master.mdf, master.ldf, and error file.
Then after stoping SQL agent you can move files.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / jijo
Take the full backup of sysdatabse and specify backup
location into d:\
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / amr
1st u have to stop sqlserver then u can catch file and copy
it anywhere !!
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anwar hayat
Stop MS SQLServer Services and copy mdf ldf files in desire
location.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / samar
plz explain in brief,
if u can send me screen shots for process , it ll be good
for undetstandin
mail id: summer_sinha@yahoo.com
| Is This Answer Correct ? | 0 Yes | 1 No |
How to change the ownership of a schema in ms sql server?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
how to take backup bcp out for a column in table in sql server?
how to count datewise data in sqlserver
4 Answers CarrizalSoft Technologies, IndusInd Bank,
Explain acid?
How to start sql server browser service?
Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem
What are types of storage modes? : sql server analysis services, ssas
What is the difference between 2-Tier architecture and 3-Tier architecture
15 Answers CTS, MCN Solutions, Oracle,
How to change server name in sql server?
List all types of constraints in sql server?
What is meant by datasource?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
