I have one user account on an SQL Server, and one Database, and I dont have access to the server. Is there a way I can backup the DB, can an SQL DB be turned into a file of some sort?Where did you want to backup to? The same disk? Accross a network? To tape?
If you just want to export a text file, you can create a DTS process that will run daily (nightly) that will export your database as a csv. CSVs are comma-delimited text files that are easily importable back into SQL Server or most any other DB-type apps, including Excel.|||Originally posted by lebhead
Where did you want to backup to? The same disk? Accross a network? To tape?
If you just want to export a text file, you can create a DTS process that will run daily (nightly) that will export your database as a csv. CSVs are comma-delimited text files that are easily importable back into SQL Server or most any other DB-type apps, including Excel.
how do you create and export a CSV?
No comments:
Post a Comment