Search results for query: *

Were you backing up the transaction log before you upgraded to 2008? What it sounds like is the database(s) recovery mode is set to Simple. When this is the case you will not be able to backup the transaction file. With Great Power Comes Great Responsibility!!! [afro] Michael

I actually had the same issue as well as another with cleaning up database backup files. After doing research which indicated that it was a bug that was resolved in the latest service pack. I installed service pack 4. I went from SQL Server 2005 SP2 to SQL Server 2005 SP4 and it resolved both...

I figured it out. Once the users were created and mapped them to the appropriate databases. I was able to run the following command DENY VIEW ANY DATABASE to login_name and that allowed them to only see there databases from object explorer. With Great Power Comes Great Responsibility...

Thanks for the response Bill. I was able to restrict the access to the other databases. All except the system databases. Not sure of the best way to remove access for these. Also when the user account logs onto the server it still sees all of the databases in the object explorer. Now...

I have a SQL Server (2008 R2) with 10 databases. I have to grant a user access to a database using management studio. Is it possible for me to grant the user access to the server but restrict access to the other databases. Truthfully I would like for them to only see the database they need to...

Figured out a solution to this one. Did not have to grant all users access to the repository database since only a couple would be using the feature. Did write a script to give all users access in case this changed in the future though. With Great Power Comes Great Responsibility!!! [afro]...

Is there a way to map all users to a particular database? I have a server with multiple users that have there own databases. In addition to there own databases I need to grant them all access to a repository database. Without going through each user login is there a way for me to grant them...

I actually figured this one out. I had 2 instances of management studio open and somehow not all of the settings took when I was executing the sp_send_dbmail under the non SysAdmin user between instances. With Great Power Comes Great Responsibility!!! [afro] Michael

I am having an issue running the sp_send_dbmail from a non sysadmin account. I am running SQL Server 2008 R2 SP1. I gave the user permissions to the DatabaseMailUserRole under the msdb database however anytime I try to run the sp_send_dbmail I get the following error message: Msg 14607, Level...

I am running into an issue that I hope someone can shed some light on. I have a job that backs up the transaction logs every 30 min. When a new database is added the transaction log backup job fails because the new database does not have a corresponding full backup. I was wondering what is the...

The problem that I am having is we are doing a migration from one environment to another, and I have no control over how the backups are named. I completely agree with your naming convention however it is not in my control. With Great Power Comes Great Responsibility!!! [afro] Michael

Is it possible to determine the database name on the server from a backup file? By this I am not referring to the logical name which can be retrieved from the RESTORE FILELISTONLY command. I am referring to that actual database name as how it was stored on the server. Any help would be...

Thanks for your response Bill. I am going to look into using this method. With Great Power Comes Great Responsibility!!! [afro] Michael

I have been tasked with trying to move sql server user accounts from a sql server 2000 instance to a sql server 2008 R2 box. I have about 200 databases each with unique user ID's. I know that the security information is stored in the master DB. Is it possible for me to extract the user name...

I am trying to find a good SQL Server Monitoring software. Does any have any recommendations or suggestions? With Great Power Comes Great Responsibility!!! [afro] Michael

Actually I figured this one out. The installer appears to be very picky. If you install over a network the install fails. Once the files where copied locally and the install was redone it worked with no problem. With Great Power Comes Great Responsibility!!! [afro] Michael

Hey guys, I'm hoping someone can help me out with this. I'm building a Citrix Farm hosted at Amazon Web Services. Windows 2008 R2, SQL 2008 R2(SP1). I get through the install and all the way to the end of the config and it fails at Registering Citrix Administrators Specifically: Setting...

What about using the Network Service Account? I guess what I am trying to figure out is what are the pros and cons of the Local Service Account, the Network Service Account, and a Domain Account? And which one would be considered a best practice for a production server and why? This is one...

When selecting a user account to start an sql server instance what is the best service account to use. Should one of the service accounts be used or should a watered down domain account be used. I know that for 2000 it was recommended to use a domain account. Can some one explain to me the...

I actually figured out how do to relate the session to the temp table instance in the tempdb. If you look up the table by object id from your session it will give you the id of the object from your session. DECLARE @OBJID BIGINT SELECT @OBJID = OBJECT_ID('TEMPDB..TABLENAME') SELECT NAME...