If I use attach/detach to move my log file to a different drive, will
it break any of my permissions for the sql logins. If so, how can I fix
this.
This all stemmed from needing to setup log shipping to another server
for redundancy. Step 1 says to create a share where the log files
reside. Well the sql server was installed by a previous employee and
the log files are in the same directory as the data files. I would feel
more comfortable (security wise) if I only shared out the directory
where the log files lived.
If anyone thinks that I am traveling down the wrong path or has any
suggestions, please let me know.
Thanks
3  3171 
> If I use attach/detach to move my log file to a different drive, will it break any of my permissions for the sql logins.
No, this will not break permissions if you immediately reattach to the same
instance. Problems with orphaned users occur when you a attach/restore to a
different instance or attach/restore after dropping logins.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"buster" <fu*****@yahoo.com> wrote in message
news:11********************@c13g2000cwb.googlegrou ps.com... If I use attach/detach to move my log file to a different drive, will
it break any of my permissions for the sql logins. If so, how can I fix
this.
This all stemmed from needing to setup log shipping to another server
for redundancy. Step 1 says to create a share where the log files
reside. Well the sql server was installed by a previous employee and
the log files are in the same directory as the data files. I would feel
more comfortable (security wise) if I only shared out the directory
where the log files lived.
If anyone thinks that I am traveling down the wrong path or has any
suggestions, please let me know.
Thanks
Dan, thanks for the quick response.
I was wondering if you could help with one more issue.
It says I need to create a share in order to do the log shipping, this
sounds a little dangerous, and I didnt know if there was a better way
to make this happen without the share.
Thanks
Dan Guzman wrote: If I use attach/detach to move my log file to a different drive,
will it break any of my permissions for the sql logins.
No, this will not break permissions if you immediately reattach to
the same instance. Problems with orphaned users occur when you a
attach/restore to a different instance or attach/restore after dropping logins.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"buster" <fu*****@yahoo.com> wrote in message
news:11********************@c13g2000cwb.googlegrou ps.com... If I use attach/detach to move my log file to a different drive,
will it break any of my permissions for the sql logins. If so, how can I
fix this.
This all stemmed from needing to setup log shipping to another
server for redundancy. Step 1 says to create a share where the log files
reside. Well the sql server was installed by a previous employee
and the log files are in the same directory as the data files. I would
feel more comfortable (security wise) if I only shared out the directory
where the log files lived.
If anyone thinks that I am traveling down the wrong path or has any
suggestions, please let me know.
Thanks
I don't think the share itself is a security concern as long as you lock
down the permissions appropriately. For example. you don't need 'Everyone'
to have access.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"buster" <fu*****@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com... Dan, thanks for the quick response.
I was wondering if you could help with one more issue.
It says I need to create a share in order to do the log shipping, this
sounds a little dangerous, and I didnt know if there was a better way
to make this happen without the share.
Thanks
Dan Guzman wrote: > If I use attach/detach to move my log file to a different drive, will > it break any of my permissions for the sql logins.
No, this will not break permissions if you immediately reattach to
the same instance. Problems with orphaned users occur when you a
attach/restore to a different instance or attach/restore after dropping logins.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"buster" <fu*****@yahoo.com> wrote in message
news:11********************@c13g2000cwb.googlegrou ps.com... > If I use attach/detach to move my log file to a different drive, will > it break any of my permissions for the sql logins. If so, how can I fix > this.
>
> This all stemmed from needing to setup log shipping to another server > for redundancy. Step 1 says to create a share where the log files
> reside. Well the sql server was installed by a previous employee and > the log files are in the same directory as the data files. I would feel > more comfortable (security wise) if I only shared out the directory
> where the log files lived.
>
> If anyone thinks that I am traveling down the wrong path or has any
> suggestions, please let me know.
>
> Thanks
> This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Tim |
last post by:
I am in the process of moving a site from one hosting company to another.
This site is fairly large, with hundreds of asp files, each with multiple
"include" statements.
The new host has a...
|
by: davidmdalle |
last post by:
Hello, I have been having a bit of trouble finding help on the safest
way to move data files to a different disk on the same server. Most
help is about moving data files to a different sqlserver. ...
|
by: Hemant Shah |
last post by:
Folks,
I need to move HOME directory of an instance to another directory.
What is the best way of doing it?
Is changing password file enough? or dies DB2 store this info in it's own
config?
...
|
by: Ron Weldy |
last post by:
In moving a ASP.NET site from a W2K IIS5 server to a new W2K3 IIS6 server,
we are having trouble with what appears to be ASP.NET server side includes
in the .shtml files. I did not set up the old...
|
by: Franck |
last post by:
Hello,
I've just moved to visual developper 2005
to do so, I also had to use the convert assistant.
what it did;
moving my file resx files that i had in a diresctory called resx
to a new...
|
by: Woody Splawn |
last post by:
I have been using SQL Server 2000 on my stand-alone machine as a back-end to
a VS.net application. It is time to switch environments and take the
application to the customer. I need to install...
|
by: fuzzybr80 |
last post by:
I am using MySQL 5.0 with a number of innodb tables whose ibdata files
are growing quite quickly and filling up the /var partition (file is
/var/mysql/ibdata1). Earlier on I followed instructions...
|
by: =?Utf-8?B?TW9iaWxlTWFu?= |
last post by:
Hello everyone:
I am looking for everyone's thoughts on moving large amounts (actually, not
very large, but large enough that I'm throwing exceptions using the default
configurations).
We're...
|
by: bwmiller16 |
last post by:
Folks -
DB2 V9.2 on SUSE 9
Is there a way other than moving the entire /sqllib/db2dump/ (Default
database path (DFTDBPATH) = /home/db2inst1 to move just STMMLOG out
of there to another...
|
by: Jim in Arizona |
last post by:
I've looked around the web but can't find anything to help me out.
I was able to get some code to move some files from one directory to
another, which works fine:
...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |
