QA Environment?

Jun 12, 2007

Good morning,

I am a DBA and my boss recently recommended that we change our QA environment so that we don't have any databases on it unless they are actively being tested. This would be to save hardware costs.

The only issue I can think of at this point is that promotion to our QA environment would take up to 2 hours for some of our larger databases if we have to restore production databases to qa for every QA run.

Is this a good idea? How do you run your QA (full or partial copy of prod)? Any input appreciated.

Thank you.

View 3 Replies

How To Deploy Updated Database From Development Environment To Live Environment?

Nov 16, 2005

I have finished a change request from our client. I need to update clients' database with the one in developments.Here is the changes i made to database:Added/Changed some tablesAdded/Changed some stored proceduresAdded data to some dictionary tableThe data in clients' current database MUST be kept. So how can I merge the changed information to clients' database?

View 3 Replies View Related

SQL EE And SQL SE In The Same Environment

Dec 5, 2007

Hi!

I work on a company where we today have one SQL Server Standard Edition and Reporting Services (SSRS) and Analysis Services (SSAS) installed on the same server.

Now we want to install SQL Server Enterprise Edition, but still have the Standard Edition installed.
We are gonna invest in one more server.

I wonder if its possible to install the database engine for both versions on one server and then install instances of SSRS and SSAS on the other server?

Can Standars Edition have SSRS and SSAS on another server than the Database Engine?
And is it different versions of SSRS and SSAS between SQL SE and SQL EE, or does SSRS and SSAS get the SQL EE benefits if the database engine is SQL EE?

Thanks in advance!

View 3 Replies View Related

24 Hour Environment

Sep 29, 1999

I have about 23 SQL servers running 6.5 SP3 or SP5a in a 24 hour environment. Most of the activity takes place between 6am and 11pm, with few transaction after 11pm. What is best to do with the main DB's transaction log, have the truncate at checkpoint option checked OR back up the transaction log a couple times a week? The Database is backed up every 6-8 hours.

Thanks in advance for your opinions/help.

LN

View 3 Replies View Related

DTS Environment Variables

Nov 21, 2005

I have about 40 DTS packages that I want to run against three different databases on the same server. Can someone suggest an easy way to run these jobs and differentiate each time which SQL or INI file to use.

Thanks,

John Shaening

View 1 Replies View Related

The Database Environment

Jan 14, 2004

Hello, everyone:

What is difference between testing environment and product environments for MS SQL Server? Thanks a lot.

YTZ

View 1 Replies View Related

SQL In A Wireless Environment

Mar 12, 2007

Jimmy writes "We use a software that stores its database in SQL. We currently have a server box running Windows 2000 Server with SP4 and SQL Server 2005 with SP2 which holds the database. The server is wired in but we have several other stations that connect to the database wirelessly.

The problem is with our wireless stations.
When a wireless client travels from one access point to a repeater, it'll drop the connection for that moment. Once it picks up the wireless connection again, it requires closing out of the software and going back into it so it reestablishes the SQL connection to the server.

Is there a solution for a seamless reconnection with SQL for our wireless clients? Is this a problem with our software or SQL? Please advise. Thank you."

View 2 Replies View Related

SQL Developer Environment

Nov 6, 2007

Hi Guys,
Im new to SQL Server 2005.
In our organization, I was tasked to implement and maintain
MS SQL 2005 database.
We have several system developer and they are using MS SQL 2005
as a backend database.

Currenty, they are responsible for designing their own databases required by their application.
My concern is that I want to restrict access to my SQL server that only the DB administrator can access the
database server.

My question is that, how they can design their databases without accessing the database server. Is it
possible for them to access SQL Server with some restriction? I mean, I want to impose some security measures
that they can only access objects within their scope.

Our current scenario is that they have MS SQL Express version installed in their pc and from that terminal
they can design and test their application and after everything is in place, Its me who will migrate their
respective databases for production in MS SQL 2005 server.

Hoping you can provide me the best alterntive to this query.

Thanks a lot.

View 3 Replies View Related

Development Environment Needs?

Jul 20, 2005

Trying to figure out what development enviroment we need in order todo the following:- develop a non-native SQL server stored procedure;- call a web service or java program from the stored procedure;- return static values;- call the stored procedure from a view.How do I get a hold of the right tools and what do I need to put thepieces together?Obviously, I've not used SQL server and I'm looking for the basicstarting point.Thanks!

View 5 Replies View Related

RDA Setup Environment

Aug 23, 2007

Hi,

I'm currently using the setup below for my RDA testing. Is there any problem with this setup?

connected connected
Client Apps (SQLCE 3.0) -----------------> Windows Server 2003 (Web server) ----------------> Windows XP (SQL2005)

previously was using windows XP to act as web server and have SQL server reside inside the same machine but having 10 connection limitation from windows xp where only 10 client can connect to the machine. The current setup moves the web server out to windows server 2003 and i believe it solves the 10 concurrent connection limitation but how about the SQL server? is it limited to 10 connection from windows server 2003 also? (Windows XP is my testing server, Windows Server 2003 contains important test data for the whole company) . I tried with concurrent RDA pull for 40 client concurrently with 1 pc having 10 client apps but obtain not really satisfying results. Pulling one table (20Mb) needs 1 to 2 mins through LAN networks but pulling concurrently with 40 clients takes up to 20 - 30 mins.

Any advice? Thank you and have a nice day.

Regards,
Ben

View 1 Replies View Related

SQL Express Environment

May 5, 2006

Novice SQL Express User...

Now that I've installed SQL 2005 Express Advanced, shouldn't there be a DB Environment I can work with? There must be a configuration mistake because I can't see the "container?" Prior to SP1 I had SQL 2005 Express installed and I could open and use SQL; however, once I loaded SP1 that stopped. I thought if I load the "Advanced" I would be "back in business."

Thanks,

Tony

View 1 Replies View Related

SQL Hospital Environment

Sep 25, 2007

i am working in hospital environment. i am a novice in SQL. i have an urgent issue to answer which is around numbering the order of theatre event for the same patient based on the into theatre time. Patients can go to theatres several times in the single hospitalisation. we need to order as 1, 2, 3 and so on based on the into theatre time which is date/time format. your help is much appreciated. thanks.

View 5 Replies View Related

Environment Variable

Jul 17, 2006

hi,

can you show me how to get the value of an environment variable from a script task?
thanks!

View 3 Replies View Related

Confguring The Environment

Dec 12, 2007

Hi

I have a SSIS package. Right now its doing a data flow task from flat file to an OLEDB destination.

Now If i have to move to a new environment , I have the exactly the same tables but the server name is different.

Is there any way i can configure this from .NET CODE.

thanks

Sai

View 5 Replies View Related

User Environment Error

Nov 11, 2002

Do you guys know how to fix this error?

windows cannot find the local profile and is logging you on with a temp profile? how do you get around this? Thanks.

View 1 Replies View Related

Production And Test Environment

Jun 25, 2004

Sould one has a seperated environment for production and test system? How do you do it on a same server? Install two instance? How do you seperate test DBs from the production DBs?
Please advise...Thank you

View 2 Replies View Related

Creating A Test Environment

Mar 28, 2007

I just got my first job doing some DBA work (junior level) in a small company using SQL Server 2000.

I would like to make a copy of the production DB and use it for development of SP's, DTS packages and views.

What is the safest way for me to copy the entire production DB, to a new DB on the same server?

Should I create a new DB, and do a restore of the production backup?

Any help would be appreciated,
Thank you.

View 3 Replies View Related

Log Shipping Vs. Clustered Environment

Jun 20, 2007

I am embarking on a project to upgrade our SQL server environment. I'm curious for some opinions on the relative benefits of Log Shipping versus a Clustered environment and you have any experience that has helped form your opinion on the issue?

Thanks,

Marc

View 3 Replies View Related

SQL Server Express In A Lab Environment

Aug 18, 2005

I'd like to allow students in a lab to use the Express Manager and T-SQL to create their own databases. I think I've figured out just about everything - but the last step. Here's my thinking on how to do this:

1. Students are power users, not local admin
2. Created a login for the builtinpower users group as follows:
create login [BUILTINPower Users] from windows with default_database=[master]
go
exec master..sp_addsrvrolemember @loginame = N'BUILTINPower Users', @rolename = N'dbcreator'
go
3. Now students can start the Express Manager and connect to:
localhostsqlexpress using Windows Authentication
4. After they do, they can open and run a script creating a database and populating it with tables and records.
5. All good up to here... but when trying to access the new database using VB Express (file based, not a remote connection) access is denied.

The problem is in the NTFS file permissions being assigned to the new database mdf and ldf files. Local administrators and the builtin Network Service accounts have permissions, but the student who created the database gets nothing... So the student is denied access to the mdf and ldf files when trying to make a connection to them using VB Express.

I can go in with a different account having admin privileges are assign privileges to power users for the mdf/ldf files after they're created but this isn't what I need (students need to work whenever they want without waiting for an admin to fix the file permissions).

Maybe I'm going about this all wrong? If I have to I can insist on students always using VS 2005 instead of VB Express and use connections to a remote database (no problems doing this), but I'm still hoping for an express solution.

I'm new to this forum, so apologies if this is a dumb question (but even if it is - can anyone point me in the right direction?)

Thanks

Mike Morrison

View 1 Replies View Related

Dual Redundant Environment

Mar 15, 2007

any tutorial on how to setup SQL Server in a dual redundant environment ?

thanks

View 3 Replies View Related

SQL 2005 In Hosting Environment

May 2, 2007

Hello,

I want to offer a SQL 2005 server in back-end configuration for my hosting clients. Basically this means that they administer the DB with a webbased tool and the DB server it self is configured in the backend and has no direct connect to the internet. The DBs can only be access from the frontend web server.

- What security considerations should I take to use this server in a public hosting environment?
- We only allow webbased administration, no direct connect to the server are allow and possible.
- Multiple databases will exist on the same server from different customers.

I really would like to have as many information as possible. There is not much usefull information available on the web or in the books I own about SQL.

The question should actually be: what do you want to prevent from happing on your servers by authenticated users and ofcourse unwanted users. And how to do this.

View 6 Replies View Related

Securing Production Environment

Feb 18, 2008

Hi,

I want to make some steps towards securing production database.

1. Give limited rights to Developers, i.e. db reaonly, db writedeny
2. Make strong password for local and Domain
3. Use Windows authentication
4. Enable log for 'Failed Login' attempts.

What steps I need to take in addition to those?

View 4 Replies View Related

Multi-server Environment

Oct 1, 2007

We are currently managing about 75 SQL Server instances. Each instance contains jobs (backups, index work, admin, etc) which report back to a central instance for monitoring. This is working well, but each time I need to change one of the jobs, I am having to log into each instance to do so.

I have recently played with Multi-server Environment, using a master and target, to see if this might help. There is relatively little written about Multi-server in books-online, and I am left with a question.

All jobs appear to be exact duplicates. But I don't want exact duplicates. For example, on the various target servers, I would like for the backup jobs to run at different times, and write to different directories. How are the rest of you working around this situation, if you are using Multi-server Environment?

View 1 Replies View Related

Using Environment Variables In Dtexec

Jul 6, 2007

Hi all,

does anybody know if it is possible to use environment variables when calling dtexec utility?

I'd like to run packages stored on server's file system from directory that I've had specified in an environment variable called SSIS_PackagesPath.

Now, I'am trying to write dtexec command, where path to the actual SSIS package would be concatenation of environment variable (i. e. path to package directory) and name of package itself (written explicitly). Is this syntactically possible?

The reason behind is to be able to easily modify package storage directory for multiple scheduled jobs that run SSIS packages.

Any other ideas are hapilly welcomed.

Thanks,

Marek

View 3 Replies View Related

Log Shipping In Workgroup Environment

Jul 19, 2007

I have two SQL servers that I am trying to setup log shipping on. I am unable to get the restore of the initial database to work on the standby server. It gets a "unable to open file" error when trying to do the restore.

I have created a "syncaccount" user on both machines, and both have same password. I have used configuration manager to set the user/password for the agents on both servers.

I have given syncaccount admin access. I have added syncaccount to the shares on both servers.

Wy am I getting this error.

Does anyone else think it is VERY difficult to make this function work.

View 7 Replies View Related

Drives In A Cluster Environment

Jul 24, 2006

Hi,

I have a SAN and configuring a cluster on SQL 2005. I initially created a Quorum drive when setting up the cluster and now added 4 more drives to the physical node but when I try to install SQL that drive cannot be located.

Do we need to create all the drives when installing the cluster or what is the way to add the drives later on.

Thanks

Anup

View 9 Replies View Related

Replication Environment Configuration Help!!

Oct 24, 2007

I have a production server log shipping to a secondary server every 30 minutes (both SQL 2000), which the second server is used for both a warm standby server and for reporting from users. Issue: the log shipping locks the DB so reporting can't be done until the load is finished, the load to the second set of databases has taken up to 15 minutes to finish allowing the users only 15 minutes to run reports, this is not acceptable. The server also needs to be used for DR.

I am looking for another solution, I can't use Transactional Log shipping as not all of the tables in the databases have a primary key identified. So, I am looking for a real-time or near real-time reporting server that is more available to running reports and a warm standby server for Disaster recovery. I am trying to figure out what SQL Server 2000 has to provide (or even 2005 or 2008?) or I am also looking at some third party software, but not sure what is the best for a reasonable price.

Any help is appreciated.

Thanks....JB

View 3 Replies View Related

Configuring Environment For First Time

Feb 8, 2006

Each time I start of SQL Server Management Studio, I get the following message "Microsoft SQL Server Management Studio configuring environment for first time".

I had a simiiliar message with Visual Studio 2005 and fixed it by setting the setting to look on local disk drive. I cannot find a similiar setting in SQL Server 2005.

Any suggestions on how to resolve?

View 4 Replies View Related

Install RS In Clustered Environment

Feb 13, 2008

I have a two node failover cluster(Active/Passive). I am planning on installing the Report Server database on the failover instance.
Do i need to install RS on both the nodes?

thanks?

View 3 Replies View Related

Reindexing On A Mirror Environment

Oct 18, 2007

All,

I've got a medium sized database in a mirror configuration with witness. The database size is about 300gb and I would to reindex all of the tables in the database. My process would go something like this:

1) Backup principal
2) Break the mirror
3) Set the principal database to simple recovery mode
4) Perform the reindexing
5) Backup the principal and transfer that backup to the mirror

6) Restore the backup
7) Re-establish the mirror

Does anyone see any issues with the process itself?

Regards,

Ian

View 1 Replies View Related

Two Way Transactional Replication In WAN Environment

May 5, 2007

Hi

Can we do two way transactional replication in WAN environment user SQL SERVER 2005 STANDARD EDITION.

Regards,

Anand

View 1 Replies View Related

WSUS Reconstruct The Environment

Oct 12, 2006

Hi All
Im a new comer to the site and wsus.
I inherited a functional wsus server it was great but due to a demand for improved reporting features I attempted to install the Wsus rollup reporting sample. Im uncertain as to how but I hashed up the installation to the extent that it corrupted the MSDE installation. It was suggested I remove wsus and reinstall.

At this point I made another error. I was told that WSUS 3 had improved reporting features (and indeed it does, its infinitely better in that respect) so I signed up with Microsoft and downloaded the installation file.

WSUS 3 uses SQL 2005 for Windows so my back up of the MDF & log files were rendered useless.

I have since removed WSUS 3 reinstalled a fresh copy of WSUS Sp1 and run the synchronisation job.

The fresh install does not have my machines/groups setup nor any of the updates approved.

I would like to know is there any way I can use the MDF file and its log to rebuild my WSUS environment?

View 3 Replies View Related

Development Environment Setup

Apr 16, 2008

Hi,

I am looking for advice with setting up a 2005 environment for development, debugging and testing using a laptop as the development platform and a desktop pc as the database engine both connected via a LAN. The current configuration is that all the full blown Visual Studio / SQL development software is installed on the development laptop and can go wherever the developer goes, and the Express versions are installed on the desktop pc so that the development database has an unbroken connection with the network. This setup worked well in the past for developing applications that use a typical database interface. The applications could be completely developed and tested before it went live on the corporation��s full blown production SQL server. Now we want to utilize the Reporting Services/SSIS in our development efforts and I would like to know what parts of the development software (Express vs. Full) should be installed on what unit (laptop vs. desktop) to fully develop and test using Reporting Services before we move to production? And anything else, like what services need to be running on what units etc.

TIA
Jake

View 5 Replies View Related