Software to automate backups for SQL Server 2008 databases
I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up [...]
Answer Question
| June 29, 2009 4:44 PM
Automated backup, Backup & recovery, Backup software, SQL managment Studio, SQL Server 2008, SQL Server backup, SQL Server backup and restore, SQL Server Management Studio
I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up [...]
Answer Question
| June 29, 2009 4:44 PM
Automated backup, Backup & recovery, Backup software, SQL managment Studio, SQL Server 2008, SQL Server backup, SQL Server backup and restore, SQL Server Management Studio
Backing up SQL Server 2008 databases to a tape drive
I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?
Answer Question
| June 25, 2009 10:36 PM
Backup to Tape, SQL Server 2008, SQL Server backup, SQL Server database, Tape Backups
I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?
Answer Question
| June 25, 2009 10:36 PM
Backup to Tape, SQL Server 2008, SQL Server backup, SQL Server database, Tape Backups
Retrieving System information
I need to retrieve logins and users for all databases by server for SS2000 – 08. Querying the system tables sysservers, sysdatabases, sysloginns and sysusers provide the information. But how do I collect all that information with one query hopefully that I can run against all serves in the enterprise.
Answer Question
| June 18, 2009 5:53 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008
I need to retrieve logins and users for all databases by server for SS2000 – 08. Querying the system tables sysservers, sysdatabases, sysloginns and sysusers provide the information. But how do I collect all that information with one query hopefully that I can run against all serves in the enterprise.
Answer Question
| June 18, 2009 5:53 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008
How to automatically update Child Table with Insert Trigger and Table-UDF
I have SQL Server 2008 and Visual Studio 2008 and am trying to automatically insert new records into a child table based on new inserts into its parent table. I know that this should be simple: via an insert trigger. However, the complexity is that the new records into the child table need to be [...]
Answer Question
| June 12, 2009 3:14 PM
SQL Server 2008, SQL Server triggers, T-SQL 2008, UDF, Visual Studio 2008
I have SQL Server 2008 and Visual Studio 2008 and am trying to automatically insert new records into a child table based on new inserts into its parent table. I know that this should be simple: via an insert trigger. However, the complexity is that the new records into the child table need to be [...]
Answer Question
| June 12, 2009 3:14 PM
SQL Server 2008, SQL Server triggers, T-SQL 2008, UDF, Visual Studio 2008
Errors creating database with SQL Server 2008 I&M Training Manual
I’m going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here’s what happens: CREATE DATABASE TK432 ON PRIMARY ( NAME = N’TK432_Data’, FILENAME = N’c:testTK432.mdf’, SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ), FILEGROUP FG1 ( NAME = N’TK432_Data2′, FILENAME = N’c:testTK432.ndf’, [...]
Answer Question
| February 6, 2011 4:11 PM
CREATE DATABASE statement, SQL Server 2008, SQL Server 2008 error messages, SQL Server 2008 training, SQL Server administration
I’m going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here’s what happens: CREATE DATABASE TK432 ON PRIMARY ( NAME = N’TK432_Data’, FILENAME = N’c:testTK432.mdf’, SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ), FILEGROUP FG1 ( NAME = N’TK432_Data2′, FILENAME = N’c:testTK432.ndf’, [...]
Answer Question
| February 6, 2011 4:11 PM
CREATE DATABASE statement, SQL Server 2008, SQL Server 2008 error messages, SQL Server 2008 training, SQL Server administration
Free Chapter – Hardening a SQL Server implementation
Another free chapter download is available on the IT Bookworm Blog. Written by: Ross Mistry and Hilary Cotter Book: Microsoft SQL Server 2008 Management and Administration Overview: “If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert [...]
Answer Question
| April 24, 2009 3:24 PM
Database security, Free Chapters, Hilary Cotter, Ross Mistry, Sams Publishing, SQL Server, SQL Server 2008, SQL Server security
Another free chapter download is available on the IT Bookworm Blog. Written by: Ross Mistry and Hilary Cotter Book: Microsoft SQL Server 2008 Management and Administration Overview: “If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert [...]
Answer Question
| April 24, 2009 3:24 PM
Database security, Free Chapters, Hilary Cotter, Ross Mistry, Sams Publishing, SQL Server, SQL Server 2008, SQL Server security
Transaction log for read only database…
Hello there, I am currently studying for the 70-432 (MCTS SQL Server 2008 I&M) exam and I am using Microsoft 70-432 Training Kit by Mike Hotek. At some point the book claims “when a database is placed in READ_ONLY mode, SQL SERVER removes any transaction log that is specified for the database. Changing the database [...]
Answer Question
| May 14, 2009 2:53 AM
70-432, SQL Server 2008, SQL Server logs, SQL Server transaction logs
Hello there, I am currently studying for the 70-432 (MCTS SQL Server 2008 I&M) exam and I am using Microsoft 70-432 Training Kit by Mike Hotek. At some point the book claims “when a database is placed in READ_ONLY mode, SQL SERVER removes any transaction log that is specified for the database. Changing the database [...]
Answer Question
| May 14, 2009 2:53 AM
70-432, SQL Server 2008, SQL Server logs, SQL Server transaction logs
SQL Server 2008 extended stored procedures
I have created several extended stored procedures in SQL 2008 which when i run always return a NULL. I call these XP’s from within a stored procedure. They work fine in SQL 2005 and SQL 2000. One thing i have noticed is when i click on the properties of the xp the path to the [...]
Answer Question
| March 26, 2009 10:41 AM
SQL Server 2005, SQL Server 2008, SQL Server 2008 extended stored procedures, SQL Server extended stored procedures
I have created several extended stored procedures in SQL 2008 which when i run always return a NULL. I call these XP’s from within a stored procedure. They work fine in SQL 2005 and SQL 2000. One thing i have noticed is when i click on the properties of the xp the path to the [...]
Answer Question
| March 26, 2009 10:41 AM
SQL Server 2005, SQL Server 2008, SQL Server 2008 extended stored procedures, SQL Server extended stored procedures
SQL Server with domain accounts
When we install SQL 2005 servers, we usually have a collection of domain accounts for the services that will be running on that server. We usually log on to the server using a local account without logging into the domain. However, it seems to not recognize the domain user accounts and we end up using [...]
Answer Question
| March 21, 2009 3:39 PM
SQL Server 2005, SQL Server 2008, SQL Server Domain Accounts
When we install SQL 2005 servers, we usually have a collection of domain accounts for the services that will be running on that server. We usually log on to the server using a local account without logging into the domain. However, it seems to not recognize the domain user accounts and we end up using [...]
Answer Question
| March 21, 2009 3:39 PM
SQL Server 2005, SQL Server 2008, SQL Server Domain Accounts
Looking for detailed synchronization logging in SQL Server 2008
We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the detailed, timestamped [...]
Answer Question
| March 21, 2009 2:57 PM
SQL Server 2000, SQL Server 2008, SQL Server replication, SQL Server synchronization, SQL Server upgrades, Upgrade from SQL Server 2000 to SQL Server 2008
We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the detailed, timestamped [...]
Answer Question
| March 21, 2009 2:57 PM
SQL Server 2000, SQL Server 2008, SQL Server replication, SQL Server synchronization, SQL Server upgrades, Upgrade from SQL Server 2000 to SQL Server 2008
SQL Server 2008: SSIS pakage with parameters
I need to create SSIS package with user entered date parameter. I have two questions: 1. How I can promt the parameter when I test the package in debyg mode. 2. How can I put on the begining of the package design condition: Global Variable gvar_Date datetime; If @p_Date is null Then gvar_Date = getdate() [...]
Answer Question
| March 17, 2009 8:43 PM
SQL Server 2008, SSIS Package, SSIS Package 2008
I need to create SSIS package with user entered date parameter. I have two questions: 1. How I can promt the parameter when I test the package in debyg mode. 2. How can I put on the begining of the package design condition: Global Variable gvar_Date datetime; If @p_Date is null Then gvar_Date = getdate() [...]
Answer Question
| March 17, 2009 8:43 PM
SQL Server 2008, SSIS Package, SSIS Package 2008
The hierarchyid data type in SQL Server 2008
In regards to the hierarchyid data type in SQL Server 2008, what is the solution if the parent node gets deleted?
Answer Question
| February 25, 2009 8:52 PM
Hierarchy data, SQL Server 2008, SQL Server Data Types
In regards to the hierarchyid data type in SQL Server 2008, what is the solution if the parent node gets deleted?
Answer Question
| February 25, 2009 8:52 PM
Hierarchy data, SQL Server 2008, SQL Server Data Types
What Is Your SQL Server 2008 Adoption Rate?
http://benchmarkitconsulting.com/colin-stasiuk/2009/02/19/please-vote-what-is-your-sql-server-2008-adoption-rate/ SQL Server 2008 RTM is over 6 months old now and I’m wondering what people are seeing so far in terms of adoption rate. What I’ve seen so far in the environments that I’ve been working on definitely falls in the 1% – 25% category. What has everyone seen in the environments that they [...]
Answer Question
| February 19, 2009 8:47 PM
SQL Server 2008, SQL Server 2008 Adoption, SQL Server upgrades
http://benchmarkitconsulting.com/colin-stasiuk/2009/02/19/please-vote-what-is-your-sql-server-2008-adoption-rate/ SQL Server 2008 RTM is over 6 months old now and I’m wondering what people are seeing so far in terms of adoption rate. What I’ve seen so far in the environments that I’ve been working on definitely falls in the 1% – 25% category. What has everyone seen in the environments that they [...]
Answer Question
| February 19, 2009 8:47 PM
SQL Server 2008, SQL Server 2008 Adoption, SQL Server upgrades
SQL Server 2008 Export data problem
Hi I’m trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy. Firstly I created a new empty [...]
Answer Question
| February 19, 2009 1:43 PM
SQL Server 2008, SQL Server backup, SQL Server Data Storage, SQL Server Export
Hi I’m trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy. Firstly I created a new empty [...]
Answer Question
| February 19, 2009 1:43 PM
SQL Server 2008, SQL Server backup, SQL Server Data Storage, SQL Server Export
SQL Server Agent job Failures
I would like to know if there is any way to get Agent jobs such as backups, Update Stats jobs to write to the error log on failure. I have written a monitoring program that looks in the errorlog and alerts on pertinent errors. I would like to be able to use this solution for [...]
Answer Question
| February 13, 2009 7:33 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server Agent, SQL Server Agent Jobs
I would like to know if there is any way to get Agent jobs such as backups, Update Stats jobs to write to the error log on failure. I have written a monitoring program that looks in the errorlog and alerts on pertinent errors. I would like to be able to use this solution for [...]
Answer Question
| February 13, 2009 7:33 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server Agent, SQL Server Agent Jobs
Can you replicate SQL 2003/8 to SQL 2000
I am upgrading a server running SBS w/SQL2000. New server will be 2003 or 2008. Would like to use old server for backup off site. Can I replicate, or would I need a new 2003/2008 license to accomplish this?
Answer Question
| February 12, 2009 1:40 PM
SBS, SQL Server 2000, SQL Server 2003, SQL Server 2008, SQL Server replication
I am upgrading a server running SBS w/SQL2000. New server will be 2003 or 2008. Would like to use old server for backup off site. Can I replicate, or would I need a new 2003/2008 license to accomplish this?
Answer Question
| February 12, 2009 1:40 PM
SBS, SQL Server 2000, SQL Server 2003, SQL Server 2008, SQL Server replication
Database Mirror connection string in sql 2008
Hi All, I have three databases which i have configured mirror on sql server 2008 for all the databases. Manual Failover with one principal and mirror. (Witness planning in the future) Using Windows authentication (Since same login and pass, neither new endpoints are created and not certificate created) This is working smoothly. I have 7 [...]
Answer Question
| February 13, 2009 7:30 PM
Database mirroring, SQL Server 2008, SQL Server Database Mirroring, SQL Server Mirroring
Hi All, I have three databases which i have configured mirror on sql server 2008 for all the databases. Manual Failover with one principal and mirror. (Witness planning in the future) Using Windows authentication (Since same login and pass, neither new endpoints are created and not certificate created) This is working smoothly. I have 7 [...]
Answer Question
| February 13, 2009 7:30 PM
Database mirroring, SQL Server 2008, SQL Server Database Mirroring, SQL Server Mirroring
Kaplan IT Learning SelfTest software
Hallo community, 70-448 Microsoft Certification Practice Products 70-432 70-433 have you purchesed this software ? what is your experience? I want to prepare for these exams. Thank you very much in advanced for the Answer. DeshRaja
Answer Question
| February 11, 2009 9:46 AM
Certification preparation, Exam 70-432, Exam 70-433, Exam 70-448, Exam cram, Exam prep tools, IT certification preparation, Kaplan IT, Microsoft certifications, SQL Server 2008, SQL Server certifications
Hallo community, 70-448 Microsoft Certification Practice Products 70-432 70-433 have you purchesed this software ? what is your experience? I want to prepare for these exams. Thank you very much in advanced for the Answer. DeshRaja
Answer Question
| February 11, 2009 9:46 AM
Certification preparation, Exam 70-432, Exam 70-433, Exam 70-448, Exam cram, Exam prep tools, IT certification preparation, Kaplan IT, Microsoft certifications, SQL Server 2008, SQL Server certifications
Copying view from remote to local SQL Server with SSMS
Hi I’m currently trying to get to grips with an upgrade from sql server 2000 to 2008, forced by an upgrade at my ISP. I’m used to using Enterprise Manager to export data from my ISP to my local machine for backup, and this process copying tables as tables, views as views and so on. [...]
Answer Question
| February 10, 2009 2:52 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2008, SQL Server 2008 administration, SQL Server Enterprise Manager, SQL Server Management Studio, SQL Server Management Studio 2008, SQL Server migration, SQL Server views, SSMS 2008
Hi I’m currently trying to get to grips with an upgrade from sql server 2000 to 2008, forced by an upgrade at my ISP. I’m used to using Enterprise Manager to export data from my ISP to my local machine for backup, and this process copying tables as tables, views as views and so on. [...]
Answer Question
| February 10, 2009 2:52 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2008, SQL Server 2008 administration, SQL Server Enterprise Manager, SQL Server Management Studio, SQL Server Management Studio 2008, SQL Server migration, SQL Server views, SSMS 2008
Error message when finding a database on SQL Server 2008
I have installed the Small Business Edition of SQL Server 2008, and I have created a Microsoft Dynamics NAV database on this SQL Server. However, when trying to locate the server from a pc in the office, it does not find the database. The error message is: “The 192.168.0.7″ server cannot be found.” 192.168.0.7 is [...]
Answer Question
| February 4, 2009 6:44 PM
Small Business Server, SQL Server 2008, SQL Server databases, SQL Server error messages
I have installed the Small Business Edition of SQL Server 2008, and I have created a Microsoft Dynamics NAV database on this SQL Server. However, when trying to locate the server from a pc in the office, it does not find the database. The error message is: “The 192.168.0.7″ server cannot be found.” 192.168.0.7 is [...]
Answer Question
| February 4, 2009 6:44 PM
Small Business Server, SQL Server 2008, SQL Server databases, SQL Server error messages
