Logshipping

Hi

I have a problem in logshipping any one help would be appreciated.

during logshipping when i am adding data (log.data,transactlog)to the
destination database when i select the destination server name(server2)it
didn't showing any drives present .instead showing local drives.if i select
3rd server then it shows perfect all the available drives .If any one knows
the error please let me know u help would be appreciated.

Thanks,
pardhi

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forum...eneral/200509/1I don't really know, but I would first look at permissions - the MSSQL
service account may not be able to access some drives. If this isn't
helpful, you should give some more details - exactly which dialogue
you're looking at (I guess you're using the maintenance plan wizard?),
which drives you can see, which drives you can't see (are they local
drives, mapped network drives, UNC paths...), what happens if you use
sp_add_log_shipping_plan directly etc.

Simon|||Thanks simon for your response.

Its weired working from home and not from office.

Thanks

Simon Hayes wrote:
>I don't really know, but I would first look at permissions - the MSSQL
>service account may not be able to access some drives. If this isn't
>helpful, you should give some more details - exactly which dialogue
>you're looking at (I guess you're using the maintenance plan wizard?),
>which drives you can see, which drives you can't see (are they local
>drives, mapped network drives, UNC paths...), what happens if you use
>sp_add_log_shipping_plan directly etc.
>Simon

--
Message posted via http://www.sqlmonster.com|||Hello, Iam also having similer problem.. would be interested to see more
coments.

Thanks,

--
admin

Admin

http://www.exforsys.com
http://www.geekinterview.com
http://www.itquestionbank.com
http://www.myitblog.com
----------------------
admin's Profile: http://www.exforsys.com/forum/member.php?userid=1
View this thread: http://www.exforsys.com/forum/showthread.php?t=5864|||Hello, I am having similer problem.. would be interested to see more
comments in detail..

Thanks,

--
techguru
----------------------
techguru's Profile: http://www.exforsys.com/forum/member.php?userid=9401
View this thread: http://www.exforsys.com/forum/showthread.php?t=5864

Logins and Permissions

I have always worked out of Enterprise Manager to view the permissions/users,
etc. in a given database (SS 2000). I often script adding permissions and
user with sp_addrolememeber and sp_grantdbaccess, etc. But let's say I want
to see all users in a database and their database level permissions
(db_reader, etc.) as well as their specific table-level and proc-level
permissions. What system stored procs are there to do that? I've got a lot
of databases and I've found Ent Mgr is just too slow.
Nevermind. I answered my own q.
"CLM" wrote:

> I have always worked out of Enterprise Manager to view the permissions/users,
> etc. in a given database (SS 2000). I often script adding permissions and
> user with sp_addrolememeber and sp_grantdbaccess, etc. But let's say I want
> to see all users in a database and their database level permissions
> (db_reader, etc.) as well as their specific table-level and proc-level
> permissions. What system stored procs are there to do that? I've got a lot
> of databases and I've found Ent Mgr is just too slow.

Logins and Permissions

I have always worked out of Enterprise Manager to view the permissions/users,
etc. in a given database (SS 2000). I often script adding permissions and
user with sp_addrolememeber and sp_grantdbaccess, etc. But let's say I want
to see all users in a database and their database level permissions
(db_reader, etc.) as well as their specific table-level and proc-level
permissions. What system stored procs are there to do that? I've got a lot
of databases and I've found Ent Mgr is just too slow.Nevermind. I answered my own q.
"CLM" wrote:
> I have always worked out of Enterprise Manager to view the permissions/users,
> etc. in a given database (SS 2000). I often script adding permissions and
> user with sp_addrolememeber and sp_grantdbaccess, etc. But let's say I want
> to see all users in a database and their database level permissions
> (db_reader, etc.) as well as their specific table-level and proc-level
> permissions. What system stored procs are there to do that? I've got a lot
> of databases and I've found Ent Mgr is just too slow.

Logins and Permissions

I have always worked out of Enterprise Manager to view the permissions/users
,
etc. in a given database (SS 2000). I often script adding permissions and
user with sp_addrolememeber and sp_grantdbaccess, etc. But let's say I want
to see all users in a database and their database level permissions
(db_reader, etc.) as well as their specific table-level and proc-level
permissions. What system stored procs are there to do that? I've got a lot
of databases and I've found Ent Mgr is just too slow.Nevermind. I answered my own q.
"CLM" wrote:

> I have always worked out of Enterprise Manager to view the permissions/use
rs,
> etc. in a given database (SS 2000). I often script adding permissions and
> user with sp_addrolememeber and sp_grantdbaccess, etc. But let's say I wa
nt
> to see all users in a database and their database level permissions
> (db_reader, etc.) as well as their specific table-level and proc-level
> permissions. What system stored procs are there to do that? I've got a l
ot
> of databases and I've found Ent Mgr is just too slow.