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
- 10606 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 |
Can you pass expressions to function parameters?
what is the difference between Delete and Truncate command in SQL
What are the advantages dts has over bcp?
What are the different SQL Server Versions you have worked on?
How to delete duplicate rows in sql server?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
Which TCP/IP port does SQL Server run on?
Difference between DELETE and TRUNCATE?
What is difference between count (*) and count column?
What is the default server name for sql server?
What is the advantage of sql server?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
-
Oracle (3253) - 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)
