i'm trying to write a script just like "copy database wizard" operation, for detaching, copy and ataching a database from a remote sql server to a local server.
Now the problem is when i try to copy the mdf file from the sql remote server to my local server.
Is it possible to create a UNC share in the remote sql server and delete after with t-sql like the Copy Database wizard does?
hope i made my self clear enought.
regards
Things like this should be planned and not ad-hoc. Though it's possible...
Code Snippet
exec xp_cmdshell 'net share sharename=<drive path>'
No comments:
Post a Comment