Prev: Code versus Int
Next: Default datetime format
From: Blake on 13 May 2010 10:34
What is the 'proper' way to allow a user to backup/dump a SQL database
directly to his desktop?

Thanks
From: Erland Sommarskog on 13 May 2010 17:45
Blake (blake.duffey(a)gmail.com) writes:
> What is the 'proper' way to allow a user to backup/dump a SQL database
> directly to his desktop?

And SQL Server is running on some central server? SQL Server needs to
have access to the user's disks. That may not be a good thing. The best
is probably to backup to some common area, and then the user can pick
up the backup from that place.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Code versus Int
Next: Default datetime format