Post reply

How to copy pub shares and logins from one sql server to another

  • September 20, 2004 at 11:46 am

    #86416

    How to copy pub shares and logins from one sql server to another. Kindly let me know.

    Thanks for the help.

  • September 20, 2004 at 11:59 am

    #523703

    I'm not sure what you mean by shares. As far as logins, search sp_help_revlogin on MSDN and you can use that script to move logins for SQL 7 and 2000.

  • September 20, 2004 at 12:16 pm

    #523708

    Hi

    Its a pubshare. Like a directory on the Server under a disk say the G:\.

    Eg: ABCD is the servername

    The directories under that are

    aaa

    bbb

    ccc

    Mike has Full control to the share \\ABCD\aaa

    Steven has Full Control to the share \\ABCD\bbb

    etc

  • September 20, 2004 at 12:38 pm

    #523710

    Those are OS level shares and not in SQL Server. Under Windows NT you can detect them with the NET SHARE command, but basically talk to your network people about that. It isn't really a SQL Server issue at all. If you are preparing for a complete rebuild disaster recovery process you might create a script to create them using NET SHARE. NET SHARE /? for more. But talk to your network people.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply