access

oops.. excuse french..
i have a client that i have 2 db on server, but there are a lot of db, and
the security is present!. 1 is for live operation, 1 is for test. The
problem is that i cannot restore db on the test. But i have DBO and backup
operator access. So.. there is a way for me to restore the db and preserve
access for another db ?
thank!Hi,
Restore can be done by an user who got "dbcreator" fixed server role or
"sysadmin" fixed role.
How to assign "DBCREATOR" to a user:-
sp_addsrvrolemember <user>,'dbcreator'
Since you are doing the backup and restore in the same SQL Server machine,
the access previlages will not be a problem.
The access issues will only araise when you restore the database to a new
SQL Server, where your Ligin/User chain will be broken.
This case you can use the system procedure "sp_change_users_login" (refer
books online) to recreate the link.
Thanks
Hari
MCDBA
"Marty" <martin.foucault@.nospam.cgsi.qc.ca> wrote in message
news:#APmf3HPEHA.2740@.TK2MSFTNGP11.phx.gbl...
> oops.. excuse french..
> i have a client that i have 2 db on server, but there are a lot of db, and
> the security is present!. 1 is for live operation, 1 is for test. The
> problem is that i cannot restore db on the test. But i have DBO and
backup
> operator access. So.. there is a way for me to restore the db and
preserve
> access for another db ?
> thank!
>

About sql server administration tools

Hi Guys,
I am planning to buy some tools that facilitate my admin of my sql server
live database. Now I don't any tools to use. I just want to inquiry that is
there any tools I can buy to facilitate my admin of sql server, such as
minitor tools, backup tools, performance tunning tools, so on. Thanks.Iter
http://sqlblog.com/blogs/rhundhausen/archive/2007/06/18/cool-dba-automation-jobs.aspx
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:EA1E5BBC-F9DA-44E9-9BC2-2BE6E11B23C7@.microsoft.com...
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that
> is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>|||Hi
Check these sites
http://www.apexsql.com/
http://www.idera.com/
regards
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:EA1E5BBC-F9DA-44E9-9BC2-2BE6E11B23C7@.microsoft.com...
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that
> is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>|||I really like a few of Red-Gate's tools. I couldn't live without SQL
Compare and SQL Backup has been very useful.
http://www.red-gate.com/
For deployment I rely heavily on SQL Farms Combine:
http://www.sqlfarms.com/
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:EA1E5BBC-F9DA-44E9-9BC2-2BE6E11B23C7@.microsoft.com...
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that
> is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>|||As already mentioned, there are a number of tools that can do the job.
That being said, you should maybe evaluate what you need is before you
go out and buy a tool. SQL Servers own Enterprise Manager/SQL Server
Management Studio, can actually do the job very well for most
administrative purposes. You should also keep in mind that the tools you
can buy, in many cases can't do much more than what you can do your self
with Managent Studio and some SQL scripting knowledge - the tools just
make it a little bit more "userfriendly".
It's my personal feeling that if you only have a few SQL Servers to look
after, you might not really need a 3rd. party tool for the admin. If you
have many servers to look after, some of the tools might be better to
give you this "over-all" view of the whole SQL server farm.
I've over the years never really felt the need to use a 3rd. party tool
for administration, but have been quite happy with Enterprise Manager /
Query analyser / SQL Server Management studio. I've then written various
scripts over time to do some specific task that I needed - and the
benefit of that is that I've learned a lot more about how SQL server
does things "behind the scenes".
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Iter wrote:
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>