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?

Answer Question   |  August 10, 2010  3:49 PM
Backup, SQL Server, SQL Server 2008, Sql Server 2008 Backup

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 [...]

Answer Question   |  August 9, 2010  5:48 PM
Active/Passive SQL Server 2005 Cluster, SQL Server 2005, SQL Server 2008, SQL Server clustering

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 Works’, NULL, ‘LastName’, 1, ”, 2), (‘Adventure Works’, NULL, ‘EmployeeId’, 1, ”, 3) INSERT INTO mdm.tblStgMemberAttribute (ModelName, EntityName, MemberType_ID, [...]

Answer Question   |  July 27, 2010  5:46 AM
Master data management, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2008 R2 Training

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.

Answer Question   |  July 27, 2010  8:11 PM
Endpoint security, forefront endpoint protection, forefront endpoint protection support, Microsoft Forefront Endpoint Protection, SQL Server 2008

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

Answer Question   |  July 23, 2010  10:34 AM
Backup, SQL 2008, SQL database replication, SQL Server, SQL Server 2008, SQL Server database

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 [...]

Answer Question   |  July 21, 2010  1:59 PM
Disaster Recovery, Shadow Copy, SQL Server, SQL Server 2008, SQL Server backup, SQL Server database

Read Excel from Sql Server 2005/2008 SQLEXPRESS
How to read the excel data’s from Sql Server 2005/2008 SQLEXPRESS

Answer Question   |  July 20, 2010  11:30 AM
SQL Express, SQL Server 2005, SQL Server 2008, SQLEXPR

SQL Server 2008 Restore Fails – There is insufficient system memory in resource pool ‘internal’ to run this query
I am trying to restore from a backup to a new database, and it processes for 8 hours and completes to 100%, and i get the following error. 100 percent processed. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Msg 701, Level 17, State 123, Line 1 There is insufficient [...]

Answer Question   |  March 2, 2012  3:10 PM
SQL Query, SQL Server 2008, SQL Server 2008 error messages, SQL Server database restore, SQL Server restore

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?

Answer Question   |  July 16, 2010  7:50 PM
Shadow Copy, SQL Server 2008, SQL Server 2008 administration, Sql Server 2008 Backup, SQL Server database

SQL Server 2008 Finding Most Recent Record Only
Hi there I have a databse that logs letter print activity The fields being Letter_Ref Print_date Any time someone prints a particular letter it leaves a date in print ref What i want to do is find the most recent print date for each letter_ref is this possible and if so how

Answer Question   |  July 12, 2010  9:26 AM
SQL Record, SQL Server 2008, SQL Server Query

how I can connect my local SQL server2008 with another one via internet?
how I can connect my local SQL server2008 with another one via internet?

Answer Question   |  April 9, 2011  3:51 PM
Remote access servers, SQL connectivity, SQL Server 2008, SQL Server connectivity

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                    50             SMITH AB 2                          Jones                     45             Leeds 3                          Patel                      38             PATEL AR What someone has done is put in the wrong data in town name and instead used details that we put in a different field. What i [...]

Answer Question   |  July 1, 2010  11:09 AM
SQL Data Set, SQL Database, SQL Query, SQL Server 2008

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?

Answer Question   |  June 28, 2010  8:03 PM
Access 2003, SQL Server 2008, SQL Server database, SQL Server Management, SQL Server Migration Assistant

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 .  

Answer Question   |  June 25, 2010  11:55 AM
SQL Server, SQL Server 2008, SQL Server User Accounts

trying to use MAC address authentication for AP from NPS RADIUS Windows Server 2008.
We are trying using MAC address authentication for AP from NPS RADIUS Windows Server 2008. Two things we are facing need help: What’s the “condition” selected and how’s the format? Secondly, How do we excute the query of SQL( 2008)table column? I do make conection successful but I do not have any action?? SQL Database [...]

Answer Question   |  November 24, 2010  7:58 PM
MAC address, Radius Server, SQL Query, SQL Server 2008, Windows networking, Windows Server 2008

Database backup terminating abnormally
m running this code for backing up and to have backup log backup database adventureworks to disk = ‘g:radvent6.bak’ mirror to disk=’g:radvent7.bak’ with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values(‘dreee’,'reserch’) backup log adventureworks to disk=’g:radvent6.trn’ after the backup log command executes shows the error as The statement BACKUP LOG is not allowed while the recovery [...]

Answer Question   |  April 11, 2011  12:38 PM
Backup, Database Backup, SQL Server 2008

Cost to upgrade to MS SQL Server 2008
My company is implementing new features in our product line that will force customers to upgrade to SQL Server 2008. I can’t make sense of MS’s pricing for SQL Server upgrades any longer (i.e., it seems they’ve gone away from the notion of a SQL Server ‘upgrade’ license). Does anyone know a ballpark figure for [...]

Answer Question   |  June 16, 2010  3:51 PM
SQL Server, SQL Server 2008, SQL Server licensing, SQL Server Upgrade

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 [...]

Answer Question   |  June 16, 2010  5:29 AM
Management Studio, SQL Server 2008, SQL Server licensing, SQL Server Query

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 [...]

Answer Question   |  June 4, 2010  3:28 PM
DBF file, SQL Server 2008, SQL Server import/export

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 database is not in a state that allows access [...]

Answer Question   |  May 25, 2010  7:16 AM
DB tracking, SQL Server, SQL Server 2008