adspace


how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server.

Answer Posted / jijo

Take the full backup of sysdatabse and specify backup
location into d:\

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain “row_number()” in sql server with an example?

1080


Does view occupy space?

1022


Can we shrink data file in sql server?

1130


How to convert character strings into numeric values?

1192


Why use identity in sql server?

1203


What is a coalesce function?

1285


Can sql servers link to other servers like oracle?

919


What are different types of constraints?

1003


What is subquery? Explain the properties of a subquery?

1063


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1300


How do I find the sql server version?

1103


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1200


What is the difference between upgrade and migration in sql server?

1185


What are the different subsets of sql?

1655


Can we do dml on views?

1039