• 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,000 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,000 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...

    ITKE366,150 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,...

    ITKE366,150 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!

    ITKE366,150 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!

    ITKE366,150 pointsBadges:
  • How to take a table-level backup in SQL Server 2008

    Does anyone know how to take a table-level backup in SQL Server 2008? Can we use the backup database command? Thank you!

    ITKE366,150 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...

    ITKE366,150 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?...

    ITKE366,150 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:...

    ITKE366,150 pointsBadges:
  • How to Repair WSS_Content Database in SQL Server 2008?

    Hi, We have SharePoint foundation 2010 and we were getting error on backup so we did run DBCC CHECKDB and found some error. Looks like I found 0 allocation errors and 55 consistency errors in database 'WSS_Content'. Now I'm not sure what i need to do to repair. How do I repair? Any drawback? How...

    GregoryGood5 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:
  • 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:
  • Upgrade SQL 2005 Cluster to SQL 2008

    We have a remote SQL 2005 server set we will be replacing with a Windows 2008 Cluster. The db supports a 3rd party app. The app has not completely endorsed for SQL 2008. If I build an active/passive cluster with SQL 2005 on Windows 2008, is there the ability to upgrade the sql server to a SQL 2008...

    tcstl95 pointsBadges:
  • Upgrading SQL Server 2000/2005 to 2008 with VMWare and EMC SANs

    Has anyone ever seen a White Paper on the best way to utilize features of both VMWare and EMC Symmetrix based SANs in a real-time or rapid batch based upgrade from SQL Server 2000/2005 to SQL Server 2008 with minimal downtime for application availability?

    SQL2K8Dude5 pointsBadges:
  • SQL Server 2005 or SQL Server 2008

    I have been trying to learn SQL 2005 from like a month or two and i think I have done a good job. Now I was about to try some security stuff in it but I saw that SQL 2008 is in market. Can any body suggest me that what is the difference between the two and can I switch to SQL 2008? What ever I...

    JrSoftwareDeveloper5 pointsBadges:
  • SQL Server Data Files and Threads

    I am reading a Microsoft Press Book MCTS Exam 70-432 and in chapter 2 it talks about Data Files and it says "SQL Server creates a thread for each file underneath a database. As you increase the number of files underneath a database, SQL Server creates more threads that can be used to read and write...

    Rick Martinez585 pointsBadges:
  • Page level lock in SQL 2008

    What is the meaning of page level lock in Microsoft SQL 2008 enterprise edition? How many records are locked?

    Akansha150 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following