Where is the SQL Data on my hard drive located?

Question

SQL Server data base. I want to backup the whole of DATA and copy whole thing into an external Hard Drive or DVD. So how to locate the DATA. Will this data then be used for query into MS-EXCEL or ACCESS installing in another Computer.

Thanks in advance.

Answer 1

STOP! You are going about it wrong. The best way to create an external backup is by using the internal SQL backup manager (copy only). Create the backups in a folder of your choosing, then copy these files to the desired location. You will need to restore the data to a SQL database on the new computer before it can be used as a data source.

Answer 2

As previously mentioned, the backup utility in your DBMS is best for this. Another option is to use the export utility to extract the data in XML or CSV format, which should expedite subsequently importing it into Excel or some other app.

Answer 3

a lot of human beings have already given great solutions i'm extremely in simple terms wanting to reinforce their case. formatting the tensepersistent to repair the reveal as a results of information risk-free practices act is complete and utter nonsense. i won't be able to believe they have instructed you this. i does no longer deliver the laptop with the tensepersistent in it besides for my very own piece on thoughts, no longer until the information substitute into encrypted which isn't the default (and it could be). i'm digressing... save your tensepersistent risk-free, substitute it out with a sparkling one (it extremely is rather ordinary), and deliver the laptop with a sparkling tensepersistent. in the event that they pick a sparkling tensepersistent then you certainly do it for them.