• SQL Server 2008: Shrink database files

    In SQL Server 2008, is there a way I can shrink my files (log and data) on all of my databases? I've already tried to use SSMS and right click each one but that's way too slow. Is there anything faster?

    ITKE1,051,995 pointsBadges:
  • SQL Server 2008: Assign Active Directory group security access

    On my domain, I need to have integrated security with my internal app. I've tried several times but it's never really worked out for me. Can I assign an Exchange / Active Directory group a role in SQL Server to have read/write access in specific tables? Just so everyone knows - this is for SQL...

    ITKE1,051,995 pointsBadges:
  • SQL Server 2008: Counts within a date range

    I need to be able to count an id and the ids duplicates when the createdate is >= 3 months or 90 days (whatever is easier) for the ids createdate. I'm using temp tables and any help would be appreciated as I'm farily new to SQL id CreateDate Counts_id 1 01/01/2015 2 1 04/01/2015 2 2 01/01/2015 1...

    jrming015 pointsBadges:
  • Recover records on SQL Server 2008 table

    In my remote SQL Server 2008 table, I accidentally deleted over a million records. Now, the server won't let me back in and access to the backup files on the server side. How can I get some of these records back?

    ITKE1,051,995 pointsBadges:
  • SQL Server log file is too big

    We are using SQL Server 2008 with full recovery model, the database size is 10 GB and the log file is 172 GB, we want to clear up the space of the log file internally, we did transaction log file backup it should be clear up , but it still 172 GB. What to do?

    mimiKh5 pointsBadges:
  • How to open SQL Server 2008 after completing installation

    I have installed SQL Server 2008 R2 and how can I start with it after this?

    chinchu5 pointsBadges:
  • Rename SQL Server 2008 instance

    I'm currently using SQL Server 2008 and I need to rename an instance. Is that possible? Thanks!

    ITKE1,051,995 pointsBadges:
  • Auto calculation of Valuation per unit in SQL Server

    Sir/mam, I have a Table of different product of mutual fund its valuation(nifty level change) is to be calculated. Each product has a different formula which takes input of some variable parameter and some static. How do I calculate row by row formula? (including Average function for eg,...

    ojha1235 pointsBadges:
  • How am I blocking connections to SQL Server 2008?

    This is a fairly specific issue, but I'm at a loss for reasons to what might be happening. We have SQL Server 2008 running on what we'll call ServerA. We can RDP in ServerA, we can ping ServerA. If we RDP into ServerA, we can open up SQL Server Management Studio and connect to all of the database...

    edwinjhoffer3,560 pointsBadges:
  • Problem with SQL Server Database File(.mdf)

    I am using SQL Server 2008 R2 and I want to check my master database file (.mdf) but failed to open it.

    edwinjhoffer3,560 pointsBadges:
  • SQL Server 2008: Job was invoked schedule 188

    After execution, it says job was invoked schedule 188. How can this be solved?

    ike66045 pointsBadges:
  • Encrypt SQL Server 2008 database for PCI compliance

    I'm pretty new to PCI compliance and from what I understand I need to secure a person's credit card info, expiration date and the card holder's name. There's not going to be storage of security codes ever. So in my SQL Server 2008 database, I would need to encrypt these 3 columns? Also, do I need...

    ITKE1,051,995 pointsBadges:
  • How to use a SQL Server 2008 database on a NAS

    We've been working on a project using Visual Studio. We need to create a local database file with our project directory so we can check into a SubVersion and have configuration management. But we keep getting an error when trying to create or attach a database on a network share. Just to clarify,...

    ITKE1,051,995 pointsBadges:
  • How to restore a SQL Server 2008 database

    Dead database. Looked at backups but the last backup made three weeks ago, then the operation was executed with an error and I didn't notice: - (mdf and ldf aren't copied by the conductor. errors in the file. using Active File Recovery had copied the mdf. then I passed Windows Check Disk. Windows...

    gioacchinolupi15 pointsBadges:
  • Exclude indexes from backups in SQL Server 2008

    Over the past few weeks, our night backups are becoming quite large because of the # of indexes in them. We've been using a simple recovery model for the backups. Would there be a way to exclude the indexes from the backups? Thanks so much!

    ITKE1,051,995 pointsBadges:
  • Query when last transaction log backup happened in SQL Server 2008

    I'm trying to query when the last transaction log backup happened in SQL Server 2008. Does anyone know how to do that? Thanks!

    ITKE1,051,995 pointsBadges:
  • Cannot open up backup on SQL Server 2008 database

    We have a query that we're using to backup our database. But when we run it, we get this error message: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'C:\Users\Kimpoy\Desktop\Backup\AcinsoftDB.Bak'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 1...

    ITKE1,051,995 pointsBadges:
  • Finding backup application log is located on SQL Server 2008

    In SQL Server 2008, we're trying to find out why our database backup failed in one of our systems. Here's what the log says: BACKUP failed to complete the command BACKUP LOG XXXXXX. Check the backup application log for detailed messages. Would anyone know where this backup application is located?...

    ITKE1,051,995 pointsBadges:
  • Error when backing up database on SQL Server 2008

    My friend and I are trying to backup a database that's located on localhost/SQL Express but we keep getting this error: Backup failed for Server 'localhost\SqlExpress'. (Microsoft.SqlServer.SmoExtended) For help, click:...

    ITKE1,051,995 pointsBadges:
  • Users accessing SQL Server 2008 database

    how can i know how many users are accessing database remotely and how much load is on database .how can it be detected in sql server 2008. pls let me know .  

    Tablestructure15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following