• Error Message when restoring a SQL server DB in SQL Server Express 2008 R2

    This error received and cannot determine resolution: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 10240MB per database. The DB.bak file is 1.67MB

    Trackster209515 pointsBadges:
  • Service Broker downside

    I have service broker up and running accross 2 instances. If data is entered/updated on table A in instance A, it will send a message to the target queue and a stored procedure is used to read in the message and perform the update to table B on instance B. Once service broker is up and running,...

    Ndoan5 pointsBadges:
  • Updating SQL express to SQL 2008 R2 on server 2008 with sharepoint 2007

    At present we are running a Windows 2008 Server which has Sharepoint 2007 installed and houses our exchange server.  Apparently only the Express version of SQL server was installed initially and now the 4GB database limit is affecting our intranet. Have been advised that we need to update to SQL...

    Weboneau5 pointsBadges:
  • SQL Server 2005 & 2008 on a Cluster in Production

    Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because...

    Lorisj3325 pointsBadges:
  • Automatic backups for production databases without taking SQL server offline

    I need to automatically create backups of my 42 production databases every night without taking my SQL Server 2008 offline. Is this possible? A full backup and transaction backup so I can step back to the exact time I need?

    ITKE345,295 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:
  • Master Data Services – Confused by mdm.tblStgMember

    Hi, In Denny's excellent blog on loading data into Master Data Services, he populated the staging tables as follows: INSERT INTO mdm.tblStgMember (ModelName, HierarchyName, EntityName, MemberType_ID, MemberName, MemberCode) VALUES ('Adventure Works', NULL, 'FirstName', 1, '', 1), ('Adventure...

    IanR5 pointsBadges:
  • Does Forefront Endpoint Protection support SQL Server 2008?

    Does Forefront Endpoint Protection support SQL Server 2008? This question is from the Microsoft Live Chat which took place on July 13th.

    ITKE345,295 pointsBadges:
  • sql 2008 export to txt for backup and incremental backup

    Hi i have one db that i want to back up, so thought id export to txt file/flat file then back that up and then daily increments into that file? cant find the steps to do it..have the wizard..

    Jordaan5 pointsBadges:
  • Mirroring SQL Server 2008 to a disaster recovery machine twice a day

    I want to mirror my SQL Server 2008 to a disaster recovery machine two times a day. Is there any free software to do this on a running SQL Server? If not, are there any cheap alternatives? Can scripts be run to copy the files over while SQL is running? Can I use shadow copy for this?

    ITKE345,295 pointsBadges:
  • Best way to back up SQL Server 2008 database?

    What's the best way to back up my SQL Server 2008 database? We are currently backing up the SQL data files during off hours but soon we'll be going 24/7 and we'll need to use maintenance plans and shadow copy. Can someone provide help?

    ITKE345,295 pointsBadges:
  • SQL Server 2008 query To Find Columns with incorrect information

    This is difficult to expalain so i will try and give you an example Record                  Surname               Age            Town 1                          Smith                   ...

    Davewaltonuk20 pointsBadges:
  • Linking users of Access 2003 to SQL Server 2008 database

    We plan to go to SQL Server 2008. We need to link our Microsoft Access 2003 users to the databases created in SQL Server 2008. Will we be able to do this considering ODBCAD32 is what we use, and the databases we create will now be 64-bit?

    Mike8005 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 2008 Management Studio evaluation edition a time bomb?

    Hi, I was just wondering if the Management Studio for SQL Server 2008 evaluation edition is also a time bomb? One of our client wants to just install the 2008 Management Studio and I was just wondering if we could use the Evaluation edition or do we have to purchase a license just to get the Client...

    Db23290 pointsBadges:
  • DBFs into SQL Server 2008

    Does anyone know of an efficient way to import DBFs into SQL Server 2008 (besides the "import into Access, then import the Access files into SQL server-method")? I don't work with SQL Server much, but I do it enough to have had this problem before (to be exact, it seems I have this problem once a...

    ITKE345,295 pointsBadges:
  • change track in sql server 2008

    HI, use Northwind Alter database [db_track] set change_tracking=on (change_retention=3 days,Auto_cleanup=on) i m running the above  command i m geting the ERROR AS Msg 5011, Level 14, State 5, Line 3 User does not have permission to alter database 'db_track', the database does not exist, or the...

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • sql server 2008 backup and restore

    can u get me the command to recover the database . my backup is in d:nor.bak . as i m running the command   >restore database 'd:nor.bak' it gives me the message as : Incorrect syntax near 'd:nor.bak'. pls let me know how to reatore . Regards, Rino

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Report Server Install Best Practices

    I am setting up my first Report server. Should the Data Engine and two databases that are automatically created reside on the Report Server or on another SQL Server machine?

    Mongo7305 pointsBadges:
  • How to Make Fixed Row Table

    Hi all My question is that i want to make the table which will accept only 500 row. even it could not accept 501th row. i mean to say i can't accept at the time of insertion not on fetch time

    DotnetDevoloper30 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