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

    edwinjhoffer2,905 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,...

    ITKE361,725 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!

    ITKE361,725 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!

    ITKE361,725 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!

    ITKE361,725 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...

    ITKE361,725 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?...

    ITKE361,725 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:...

    ITKE361,725 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:
  • SQL processor license

    On a physical server we select 2 processors. We then select SQL 2008 STD 1 socket license. since the server has 2 processors, can we assign SQL to only processor and run? If we can, can the second processor on the server be used by the OS on the server?

    Enterprises5 pointsBadges:
  • SQL 2008 system tray icon

    How can I add a system tray icon for SQL 2008 just like SQL 2000?

    Saga10 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 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