Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-12 : 08:41:41
|
| Suni writes "I have a sql server 2000 installed on my machine. I have a database hosted on a DB server which has sql server 7 on it. Using my Entrprise Manager, I was able to register the DB Server, and I am able to see the content and data of my database. But when I try making a backup or export of my database, I am not able to specify my local hard disk as a destination. It is storing the backup on the DB server itself. I only have an access to EM on DB Server, not to its hard disk space like c: or d:.How do I backup my database ?Is this problem because of difference in SQL Server version on client and DB Server ?Please advice.." |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2001-12-12 : 09:58:41
|
| If your machine is on the same network as the server, and if the SQL service account has appropriate rights, you should be able to create a backup device on your workstation by specifying UNC path: \\yourmachine\share\filename.bak |
 |
|
|
|
|
|
Unable to make a backup of a database on server.