I have 2 SQL 2008 R2 Servers which are always running (on is Prod/one is Test).
is there a way to sync Prod to Test WITHOUT using the .bak and overriding Test's Security settings?
We are setting up a test lab environment with 100 machines. We want one master testing db that gets replicated to each to run scripted application tests nightly.
My goal is to minimize the amount of work to move this thing to each of the 100 test machines. I am wondering if we need to even have the sql local and invest in a monster db server with 100 copies of the db we restore and each test machine point to their own db on that server, or if I should use db mirroring or something to get the master test db to each of those machines instead.
The option:
SQL Server Configuration Manager>SQL Server Network Configuration>Protocol for SQL_xxx (right click)>Properties, we can see two Tabs:
Tab 1: Flags
Tab 2: Certificate
If I set the value of Hide Instance= Yes, does "Force Enctyption", need to be set YES as well?
Or Force Enctyption has to be enabled in order to hide instance?
What is the recommend settings?
[URL]
Hi there, i would please like to know how to get a database online in T-SQL, I managed to get it offline in T-SQL, but know I can't get the database back online.
Please help.
If someone can please help me with the T-SQL command.
Or direct me to a link where I can get more information.
Thanks
Say I inherit from an undocumented installation of SQL server. Is there a way to extract all features, configurations and such to apply them on a different installation?For instance, if the setup was executed multiple times, can I generate a configuration.ini file contains the culmination of every setup executed?
View 3 Replies View RelatedHi,
I am doing a logshipping in sqlserver2000.
I have PrimaryServer database A and Secondaryserver A which is already existing. Now if i am trying to establish logshipping with this existing db in secondaryserver it says db A in destination is not in standy mode.
Please help me how to bring the db in standy mode that can be used to do logshipping.
Thanks
Md S.Hassan
we have a server in our environment, we would like to make a copy of it on the other server in side the company and also do the same on the remote server.
Can u tell me how to do it or any sites where i can find the stratergy's which have been already implemented for review.
Thanks and with reply is appreciated,
harry
I have configured replication between Always ON Availability Groups (Listener) (PUBLISHER), remote distributor to XYZ SUBSCRIBER...with above link ...
Now, I want to know how to replicate Data from XYZ SERVER a PUBLISHER to Always ON Availability Groups (Listener) (SUBSCRIBER)? Distributor Database being on XYZEX:
XYZ SQL SERVER as PUBLISHER, and DISTRIBUTOR
to
Always ON Availability Groups (Listener) SUBSCRIBER...
Hi,
One of our database size 90 Gb was backed up and restored on a standyby server with NoRecovery option .A Stored Procedure was written to do production Database transaction log Backup every 15 min and restore the Tlog File on Standby server.
Once the last transaction log file is restored on standby server the tlog file is deleted.
Now due to some reason the restore tlog job failed but the tlog file got deleted.
Now till we will not restore the last database backup we will not be able to start the restore tlog job.
Now the database is in restoring mode.Is there any methord to get that database online without any transactionlog.
Regards
Sufian
SQL Server 2008 R2: How security log is much secure than application log?
View 3 Replies View Related
Dear All,
One of my users created a MSDE database and did not realise that the limit is 2GB. I can not access the database. Is there anyway I can recover it?
They do not have a backup.
Could I create a new database in Standard Edition and then attach the Data and log files from the MSDE database?
Would that work?
I'm wondering if somebody could provide insight into a problem I'm having with SQL Server 2005. Although the problem is happening wthin an SSIS ETL, I don't think this problem is SSIS related.
In the ETL I need to rename a database, so I first put the database into single-user mode by issuing the command:
ALTER DATABASE foobar SET SINGLE_USER WITH ROLLBACK 30
The database then goes into single-user mode, and after the renaming occurs, I attempt to put the same database back into multi-user mode:
ALTER DATABASE foobar SET MULTI_USER WITH ROLLBACK IMMEDIATE
However, whenever I have a query pane opened against the same database in SQL Server Management Studio, the ETL fails and I get this error message:
"Error: Changes to the state or options of database 'foobar' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it."
I'm wondering why the ALTER DATABASE command does not kill off the active connections? This is on my development box, and I'm the only one connected to the database. I've tried with ROLLBACK 30 as well, same thing. If I cut and paste the same command into Mangement Studio, the command succeeds so I don't think its a permission issue (using Windows Authentication both Management Studio and the ETL are executed by the same login). If I close the query pane the ETL succeeds at restoring multi-user mode. Is there something I am missing? Thanks in advance!
Is any tool is available for replicating the Microsoft sql database..
View 1 Replies View RelatedMy environment are Win Vista, Ms sql 2005 express, Ms Sql Server Management studio express. I have a database Mysearchdb.mdf and want to replicate Myseachdb.mdf to another database with exact same features. What is the best way to do it? I don't want to create each tables, functions and store procedures manually. Thanks
View 8 Replies View RelatedIn SSMS, I connect Object Explorer to a partially contained database using a contained user login with password. This user has a database role of dbdatareader. When I try to expand the Tables in the database, I get the error:
The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
Is there a way to set permissions for the contained user so that this could be done?
I had created 2 Sql server instance in 2 servers created using VMware. From the primary server I log shipped the required databases into the secondary. Both the servers were in the same domain whose active directory was also in another server in the same virtual lab environment. My question can we have the primary sql server in one domain and the secondary sql server to which the logs are shipped in another domain by including a router also between the 2 networks for connectivity?
View 6 Replies View RelatedI am using SQL Server Management Studio 12 to try to restore a backup to a new database. I know I have done this before, but cannot seem to make it happen now. Her is what I have.
Backup file is "C:TempInProcessInspection_DataSQL_backup_2015_02_23_000012_4551393.bak" and it is for sure there.
This came from a customer of mine.I launch SQL Server Management Studio 12 and log in as SA. I right click on Databases and chose Restore Database. I choose Device then file then Add and try to browse the the named location.
When I get there, regardless if I choose All files or Bak, I see no files.I tried to upload an image of the "Upload Backup File" dialog, but MSDN would let it happen. When I get to the c:temp folder, no files appear in the window.
I am a novice in DB learning.
A few months ago, I installed the ms sql server 2005, and use it to learn the book SQL Server 2005 for dummies. It worked just fine. But after i finished the book, i uninstalled the program and deleted the express database engine. Perhaps it was an incomplete installation, yesterday when i tried to reinstall the sql server 2005, i found some configuration tools still in the directory. So i used windows to remove those tools. After that, i reinstall the sql server 2005, and changed some values in the register. The reinstallation goes well. But after it was done. I started the management studio, there's no default database engine for me to connect! All I could find in Internet is how to connect to a database engine without information about how to create one. Can anyone tell me why and help me out?
i am a novice.
Hi, all here,
Just heard about the coming release of SQL Server 2008. Anyone here got some ideas on what are significant new features in SQL Server 2008 Database Engine compared to SQL Server 2005 Database Engine? Would be very interesting to know that.
Thanks.
With best regards,
Yours sincerely,
I have the following tables on a non-SQL database that I can accessvia ODBC:UpdatedOrderHeaderOrderDetailsInvoiceHeaderInvoiceDetailsWhen an order or an invoice is added/updated a record with the ordernumber is added to the Updated table. I need to loop through theUpdated table and for each record bring the data over to thecorresponding tables on the SQL server.Does anyone have any ideas how to do this? I was attempting to do thiswith a DTS job, but I don't know how to pass the order number to eachupdate and then loop and get the next order.Any help would be appriciated. Let me know if you need any moreinformation.Thanks,Mike
View 1 Replies View Relatedi want to replicate the data from one table into another table in the same database,all the transactions in table "a" should be replicated in table "b" and vice versa.
Note:this should be done without using triggers
Very new to the world of databases. Our current database situation is a train wreck, but I'm not at the point I can fix it. So, all I'm trying to do right now is copy our 'live' database so that we can use the copy for development, without worrying about blowing things up.
Anyhow, the problem I have is that when I backup, and then try to restore the 'live' database, I'm told the drive doesn't have enough space, which is accurate (only has 1gig, needs 3gigs). FYI, EVERYTHING that has to do with our databases is currently on a 14gb partition, of which 13gigs are being used. There is an empty partition of 120gb just sitting there.
Can somebody tell me what is the best way to get this 3gb development database up? I tried to route the Data and Transaction Log paths to the empty partition, but it still seemed to want to mess with the 14gb partition and told me there isn't enough space when I tried to restore.
Hopeing this is something I can accomplish. I use MS-SQL for close to100 CMS web servers. Everytime I create a new website I have to createa new database and then use the export from SQL to SQL option and copyall data / SP's / etc... Just no security information. My question iscan I automate this? Can I create a script that will run all this?Thanks for any help, and thanks for reading.Chris AuerJoin Bytes!
View 2 Replies View RelatedUsing SQL 7.0 I'd like to replicate just schema from DB on server A to DB on server B, then be able to replicate data only form DB on server B to DB on server A. I need help!!
Thanks for ANY information you can give me...
~Jepadria
Hello
I've just installed 'SQL server 2005' and it installed the components like .Net2.0 and visual studio 2005 . before installing them I had uninstalled sql server2000 . I ran SQL management studio and tried to connect and makin' servers it doesn't allow me to connect or making any new servers...... it gives me this error
Cannot connect to local.
Additional information:
An error has occured while establishing a connection to the server. ......
error:53)
need to solve it....
We are a National Level Institutional Stock Broker in India providing trading platform to our Brokers to trade on Exchange nation-wide. We are using Compaq Proliant 8500 Serires computers in clusterd mode having RAM of 1.5 GB on each machine. We are using the Computer-To-Computer-Link (CTCL) solution / application for routing orders of brokers to the Stock Exchange. This application uses the SQL server 7.0 in clustered mode as back-end database on Windows NT Ver 4.0. On daily basis around 20,000 transactions are processed in the database.
Following are the Database Details
----------------------------------
1. Dat Size : 1890 MB
2. Log Size : 838 MB
------------------
Total Size: 2728 MB
3. File growth options: Automated file growth, By percent : 10
4. Maximum File Size : Unrestricted file growth
On April 25, 2001, we found that application was not getting initialize, we (technical team) checked all the procedures, which are getting triggered at that particular time and found all of them were ok, but application did not started.
We also suspected that one of the procedure might have been corrupted, so we re-compiled all procedures which get triggered before starting the application. After havind done so, the application was still not getting initalized / started.
We also executed following commands:
1. DBCC CHECKDB to check inconsistancy, if any but found none (log is available)
2. DUMP TRAN with no_log (To clear transation logs)
We also executed procedures one after the other sequentially, which were being executed before the application starts after binding once again.
After having done this, we also suspected that the problem might have been with "SQL Server 7.0 database engine" and therefore decided to re-start the computers, after which we found that the applicatio started without any hindrance / errors.
This has raised some issues as follows:
1. Has the database corrupted ? If yes, weather it is possible to run DBCC CHECKDB, SQL queries on a corrupted database ?
2. Was there any systems environment failure ?
If so, is it possible to run DBCC CHECKDB, SQL queries on a corrupted
database?
3. Is there any possiblity of Database Engine failure?
What can be the consequeces on Database Engine failure ?
4. Is it possible that Database Engine Failure is the cause for our case ?
Our some of the engineers are of the opinion that the SQL server need to be shutdown and re-started periodically.
1. Will this in any way avoid such re-currance in the future?
2. If this is true, we would like to have your technical feedback as to why this is necessary?
Should you require any further clarification, I shall be glad to furnish it to you in this regard.
I request you to give your techical feed back on an urgent basis as our applications are CRITICAL and needs UTMOST CARE, hence needs consistancy of database.
I shall be glad to receive your feedback at
my e-mail: gchavan@iseindia.com or (+91)(022-781 2389).
Govind Chavan, Mumbai, INDIA
SQL server DB server is in hang state. Is this is due to high memory utilization?
View 9 Replies View RelatedDear friends,
View 3 Replies View RelatedHello,
I have installed SQL Server 2005 in my PC and during the installation I
have created a predefined instance (I have used Windows autentication).
I could use correctly SQL Server till some days ago, when I changed the
password of my PC login profile.
Now, when I open SQL Server, if I click on the "Connect" button,
the following error message appears (I translate it from italian version)
Unable to connect to "CARLO"
Further information:
An error has occurred while you were trying to establish a connection to
the server. When you connect to SQL Server 2005, this error can be generated
because SQL Server doesn't allow remote connections under the predefined
settings. (provider: Provider Named Pipes, error: 40 - Unable to open a
connection to SQL Server) (Micorsoft SQL Server, error:2)
I'm sure that the error raises because I have changed my PC access
password (the program worked correctly before), but in the "Connect to
Server" window the user name and the password text boxes are disabled, so
I can't insert the new password...
Can you suggest what have I to do?
Thank you very much
Hello, everyone:
I am making disaster recovery plan and considering technical details. My question is that if I configure log shipping and primary server is failed. I have to bring up secondery server online. As warm standby server, the secondary server is Read-only. How to disable read-only?
Thanks
ZYT
I am trying to install SQL Server Sep 2005 CTP - ENTERPRISE, there are
View 1 Replies View RelatedI want to create a database on my local machine and work with it. But I am not able to see the name of my local server under "Database Engine" in the list of "Registered Servers".
Options I tried:
(1) In Registered Servers window, On Database Engine, I right clicked and in that selected "Update Local Server Registration"
(2) In Registered Servers window, On Database Engine, I right clicked and in that selected "New" -> Server Registration.
In "New Server Registration" Window, in "Server Name" drop down I clicked "Browse for more" but still in "Browse for Servers" window, I am not able to see the name of my local server in "Local Servers" tag under Database Engine.
(3) If I do File -> Connect Object Explorer -> Connect to Server window in "Server name" drop down box, if I click "Browse for more", I am able to see local server name eg. "XYZ" under Analysis Services, Reporting Services, and Integration Services but not under "Database Engine"
Please help me create a new database engine in SQL Server 2005 or list my local server under "Database engine" ?
Thanks
My company is considering purchasing MS SQL Server to run anapplication on (SASIxp). I am mainly familiar with Oracle, so I waswondering how long it would take to copy a database. Basically we havedatabase A and each night we want to replace database B with thecontents of A. How long would this take say if we had a 10GB databaseor a 20GB database.What would be the technique to do this nightly, the Copy DatabaseWizard, Snapshot Replication, Attach & Detach...? We need to automatethis process, and the source database can be made unavailable whenthis happens.Thanks,Roger
View 2 Replies View Related