It recently occurred to me that I should see if the Server backs up it's
logins somewhere/somehow. I make backups of my databases but not the logins
(I'm working on learing that export/import now). But, does SQL Server back u
p
its logins on its own, as part of its own maintenance?
--
Michael Hocksteinsystem databases
"michael" <howlinghound@.nospam.nospam> wrote in message
news:33514BD0-10D3-495E-AD7F-961BE209C322@.microsoft.com...
> It recently occurred to me that I should see if the Server backs up it's
> logins somewhere/somehow. I make backups of my databases but not the
> logins
> (I'm working on learing that export/import now). But, does SQL Server back
> up
> its logins on its own, as part of its own maintenance?
> --
> Michael Hockstein|||Logins are stored in master database, so you should back up the master
database to get a logins backup
"michael" <howlinghound@.nospam.nospam> escribi en el mensaje
news:33514BD0-10D3-495E-AD7F-961BE209C322@.microsoft.com...
> It recently occurred to me that I should see if the Server backs up it's
> logins somewhere/somehow. I make backups of my databases but not the
> logins
> (I'm working on learing that export/import now). But, does SQL Server back
> up
> its logins on its own, as part of its own maintenance?
> --
> Michael Hockstein|||Thanks.
Michael Hockstein
"David J. Cartwright" wrote:
> system databases
> "michael" <howlinghound@.nospam.nospam> wrote in message
> news:33514BD0-10D3-495E-AD7F-961BE209C322@.microsoft.com...
>
>|||It looks like the data I want to back up is specifically in dbo.sysxlogins.
I'll have to backup the master database.
Thanks
--
Michael Hockstein
"Antonio Soto" wrote:
> Logins are stored in master database, so you should back up the master
> database to get a logins backup
>
> "michael" <howlinghound@.nospam.nospam> escribió en el mensaje
> news:33514BD0-10D3-495E-AD7F-961BE209C322@.microsoft.com...
>
>
Showing posts with label somehow. Show all posts
Showing posts with label somehow. Show all posts
Tuesday, March 27, 2012
Thursday, March 22, 2012
Does RS use the MS FullText Search Engine?
Not sure what this question means, but I am being asked this by our
Technology Department.
Somehow the SQL Server instance where the Report Server databases were got
dettached. They were able to re-enable it, but they cannot restart this
engine because of a corrupt configuration file.
They are asking me whether they should keep researching and trying to fix
this file or they can just remove the engine from the cluster.
Thanks!
Ray G.The FullText search engine is not used by RS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"RayG" <RayG@.discussions.microsoft.com> wrote in message
news:44515EB2-37F2-4073-B085-023B8051A788@.microsoft.com...
> Not sure what this question means, but I am being asked this by our
> Technology Department.
> Somehow the SQL Server instance where the Report Server databases were got
> dettached. They were able to re-enable it, but they cannot restart this
> engine because of a corrupt configuration file.
> They are asking me whether they should keep researching and trying to fix
> this file or they can just remove the engine from the cluster.
> Thanks!
> Ray G.
Technology Department.
Somehow the SQL Server instance where the Report Server databases were got
dettached. They were able to re-enable it, but they cannot restart this
engine because of a corrupt configuration file.
They are asking me whether they should keep researching and trying to fix
this file or they can just remove the engine from the cluster.
Thanks!
Ray G.The FullText search engine is not used by RS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"RayG" <RayG@.discussions.microsoft.com> wrote in message
news:44515EB2-37F2-4073-B085-023B8051A788@.microsoft.com...
> Not sure what this question means, but I am being asked this by our
> Technology Department.
> Somehow the SQL Server instance where the Report Server databases were got
> dettached. They were able to re-enable it, but they cannot restart this
> engine because of a corrupt configuration file.
> They are asking me whether they should keep researching and trying to fix
> this file or they can just remove the engine from the cluster.
> Thanks!
> Ray G.
Subscribe to:
Posts (Atom)