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
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
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?
Hello there,I have a user who can bring offline a database but he cannot bring thedatabase back online.The error which pops up is:Error5011: User does not have permission to alter database dbnameALTER DATABASE statement failed.sp_dboption command failed.Any ideas?Thanks
View 1 Replies View RelatedFirst of all, Great webcast today. My question is, I have everything up and running and would like to know what to do when the machine my primary is on quits or has a some type of disaster. Do I need to manually run recovery on each db that was mirrored? I'm not currently running a witness.
thanks
I am trying to install fail over cluster for SQL and getting the below error message  :
I am using domain admin account to do the installationÂ
Server : Windows server 2008
DB Server : SQL Server 2008 (SP1)
Â
Here are the series of events which happened.
1.) Event ID: 1135
Cluster node 'XYZ' was removed from the active failover cluster membership. The Cluster service on this node may have stopped. This could also be due to the node having lost communication with other active nodes in the failover cluster. Run the Validate a Configuration wizard to check your network configuration. If the condition persists, check for hardware or software errors related to the network adapters on this node. Also check for failures in any other network components to which the node is connected such as hubs, switches, or bridges.
2.) Event ID: 1049
Cluster IP address resource 'SQL IP Address 1 (XYZ)' cannot be brought online because a duplicate IP address '10.9.8.113' was detected on the network. Â Please ensure all IP addresses are unique.
3.) Event ID: 1069
Cluster resource 'SQL IP Address 1 (XYZ)' in clustered service or application 'SQL Server (MSSQLSERVER)' failed.
4.) Event ID: 1049
Cluster IP address resource 'Cluster IP Address' cannot be brought online because a duplicate IP address '10.9.8.112' was detected on the network. Â Please ensure all IP addresses are unique.
5.) Event ID: 1069
Cluster resource 'Cluster IP Address' in clustered service or application 'Cluster Group' failed.
6.) Event ID: 1066
Cluster disk resource 'Cluster Disk 25' indicates corruption for volume '?Volume{88552e6f-aea2-11df-9790-0026b92fffa7}'. Chkdsk is being run to repair problems. The disk will be unavailable until Chkdsk completes. Chkdsk output will be logged to file 'C:WindowsClusterReportsChkDsk_ResCluster Disk 25_Disk16Part1.log'. Chkdsk may also write information to the Application Event Log.
7.) Event ID : 1066
Cluster disk resource 'Cluster Disk 26' indicates corruption for volume '?Volume{88552e05-aea2-11df-9790-0026b92fffa7}'. Chkdsk is being run to repair problems. The disk will be unavailable until Chkdsk completes. Chkdsk
output will be logged to file 'C:WindowsClusterReportsChkDsk_ResCluster Disk 26_Disk4Part1.log'. Chkdsk may also write information to the Application Event Log.
8.)Â Event ID: 1049
 (Same message as point 2)
9.)Â Event ID: 1069
    (Same message as point 3)
10.) Event ID : 1049
(same message as point 4)
11.) Event ID :1069Â
(same message as point 5)
12.) Event ID :1205
The Cluster service failed to bring clustered service or application 'Cluster Group' completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered service or application.
13.) Event ID: 1069
Cluster resource 'Cluster Disk 17' in clustered service or application 'SQL Server (MSSQLSERVER)' failed.
14.) Event D : 1049
(same message as point 2)
15.) Event ID: 1069
Cluster resource 'SQL IP Address 1 (XYZ)' in clustered service or application 'SQL Server (MSSQLSERVER)' failed.
16.) Event ID : 1205
 The Cluster service failed to bring clustered service or application 'SQL Server (MSSQLSERVER)' completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered service or application.
Â
first of all,I went through all the logs, and could not find the reason for fail-over initialization. There should be some thing logged why the failover happened? secondly after failover the service was not coming online due to duplicate IP address detection.
Later when we try  to manually bring the service online from cluster management it comes online successfully. I don't understand how would duplicate IP address get resolved when we start manually.
Lastly we see few errors related to physical disk resource between failover retries, is this could be the correlated to failover error ?
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 have SQL cluster installed on top of windows cluster on VM environment. Node1 and Node2 under Windows Failover Cluster. SQL instance is currently on node2 the instance is up and running, but SQL Cluster service remains online pending and it restarts the instance on every 5 minutes.
SQL Browser service are running successfully.TCP/IP ports are enabled and configured.If we start the SQL server agent it is on for seconds and stopped immediately  .Cluster Service is attempt to connect to the SQL service every few minutes (setting in SQL cluster resource) for the IsAlive check, if this fails then the SQL resource is restarted even if the instance was online. Hope this is what happening exactly.
[sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 ERRÂ Â [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [HYT00] [Microsoft][SQL Server Native Client 11.0]Login timeout expired (0)
00001024.00053314::2015/10/30-19:57:50.772 ERRÂ Â [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server
Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books
Online. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 INFOÂ [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] Could not connect to SQL Server (rc -1
Hi,
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
I'm not experienced with SQL Server 2005.I've got a live copy of my database running on the web server.I've got another copy running on my desktop that I make changes to.Whats the best way to sync between the two so:1. I don't have to take the application offline2. I don't loose any data from the live database3. But I can implement changes to tables and/or add new tables
View 1 Replies View RelatedIf you take a database offline to prevent users from accessing it, and then restart the server, will the database be back online when the server starts up?
If so, is there an option to prevent this from happening so that a database taken offline will remain offline until it is manually put online again by an administrator?
Hi All, first post.
I have done a bit of searching around and cant find a clear answer to this question.
Current Setup
Desktop application (c#) that connects to a SQL Server 2005 express database on the same local network as the application (currently 3 users)
It is only a very small company and has just taken on their first remote worker, but expects to take on another 6-8 over the next few months. They have asked for the database to be moved online.
The application was written in such a way that everything has been done using no stored procs, or views, it is all native SQL.
This will be my first DB hosted online and before I go ahead and do anything I just wanted to make sure what I have to do is correct, sorry if this is a very basic question, although I have been programming for a long time, I have never had the chance to do any online databases before.
Will this work.
1.Find a SQL Server 2005 Hosting company.
2.Move the database to the server.
3.Setup the users permissions.
3.Alter the connection string in the application to point to the new location.
So the only thing that would change would be a new connection string in the application preferences?
Or am I living in a dream world, because nothing is ever that simple.
One thing I am worried about is the security/visiblity of the database and data as it travels from the server to the client and back.
Thanks for any advise you can give.
Mark
Does anyone know how to do this? I am in the middle of writing a server side program, and this is one thing that I cannot do without.
Also, if anyone can answer that, how do I do the same with an Exchange 5.5 Email account?
Thanks ahead of time!
Cash Coleman
SQL server, by-mistake I updated values of a column in a database hosted online, is there any way undo the transaction. I didn't created any backup of the database. I read that still it can be recovered through the .ldf (log file) but unable to access it. Is there anyway to get access of the Log file or is there any way to recover the data.
View 1 Replies View RelatedI have database on localhost and i want to show this data on my website. I want to create a database online and want to sync with Local Host. Can it be possible syncing data automatically after some interval?
View 6 Replies View RelatedI'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!
I have my first small SQl Server 2005 database developed on my localserver and I have also its equivalent as an online database.I wish to update the local database (using and asp.net interface) andthen to upload the data (at least the amended data, but given thesmall size all data should be no trouble) to the online database.I think replication is the straight answer but I have no experience ofthis and I am wondering what else I might use which might be lesscomplicated. One solution is DTS (using SQL 2000 terms) but i am notsure if I can set this up (1) to overwrite existing tables and (2) notto seemingly remove identity attributes from fields set as identities.I know there are other possibilities but I would be glad of advice asto the likely best method for a small database updated perhaps onceweekly or at less frequent intervals,Best wishes, John Morgan
View 3 Replies View RelatedI 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 RelatedHi all; I am trying to login to an online sql database from enterprise manager;
First of all is this possible and second of all, how do I go about doing it from enterprise manager (by the way I am using MS SQL 2000)
THanks for any assistance
Hi,
I hope i'm in the right forum. Is there a way to create a DB diagram schema via ASP/HTML and publish it on-line - keeping it up-to-date?
I want to at least output a diagram schema to HTML format? Any ideas. TIA!
I've just started with a company that had a web developer in to set up their site. She set it up with Coldfusion and MS SQL Server, uploaded the whole thing to their provider, then disappeared. Then the whole thing got dumped in my lap, and I'm pretty new to both SQL Server and Coldfusion.
My first question is, how can I access the SQL Server database online? It's somewhere on the web host's site, and I have the name of it and the password, but I have no clue how I'm supposed to get a look at the thing. Is there a file I should be able to find? Can anyone provide a clue?
Thanks!
April
Hi,
Is there any method to get an historical log where appears the database status (Online|offline) ?
Regards.
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
If I want to let people come to a wesite and login and let them look at information pages and I also want the database to be used by staff of the organization.
So I would have people logging in over the Internet as well as logging in local to use the same database, but the online people would be restrickted to only some of the pages.
What would the basic database design look like.
Hi. I have a database online. I have to run some scripts, and check out my database. The ISP i have, has currently changed the IP address for the database, now I can not hook up with it via Enterprise Manager. Can someone help me. I am using Microsoft ME as the platform.
View 1 Replies View RelatedI'm currently developing an online questionnaire system for mydissertation and I have now come across a few problems. I'm developingan online approach recommendation system. The basic feature is that aclient will answer a number of questions online and based on theresults an approach will be recommended.There will be four pages with 5 questions on each site, this will allbe sent to a database and based on this an approach will be generated.I'm using mysql, php and html w/javascript for developing this but theproblem I have is that I'm not sure how the calculation andsuggestions will be coded. I've though of putting an average result into the database and then retrieve a ‘matching' approach based on thiswith querying using php.Any other recommendation is MUCH appreciated.many many thanks!
View 2 Replies View Related
Hi
I have been attempting to bring up the SQL Server Report Manager and have run into a problem.
I am working with a named instance of SQL Server 2005
This is the URL that I have entered
http://ssc20460/reportserver$ssc20460/Reports/Pages/Folder.aspx
Any thoughts would be greatly appreciated.
This is what I see on the screen when rendered
ssc20460/ReportServer$SSC20460 - /
Microsoft SQL Server Reporting Services Version 9.00.3054.00
Hi all,
I have an application running on internet, it uses SQL server datatase.
I have an question want to as: can i backup database and update database online or offline?
Thanks.
TungNT
Running PivotTable reports in Excel 2007 which are linked to a SSAS Server 2008 R2 may consume high amount of memory and cause high CPU utilization.
Detail:users may set 7 or more dimensions in row section of a Pivottable report. Some of those dimensions were containing more than 10000 members.
When refreshing such a report, Analysis Services is consuming more than 16 GB of memory, cpu utilization often goes up to 80%.
To run this report it takes arround 10 minutes. During this time other users may be unable to run reports on the server.Is there a way to control expensive MDX queries caused by some users to ensure Service availability?
dear all i tried to connect to online mssql2000 database from enterprise manager,but i can't as i have a proxy server.how can i overcome this proxy server during connection ?
View 3 Replies View RelatedI am using VB with Visual Studio Express. I am new to these tools. I have SQL Server 2005 Express installed on my machine. I think that I have the right version. I am just using Express for taking classes and teaching myself on my machine.
When I follow the examples in the book, I keep getting this error when I go to my ASP.NET configuration and click on the security tab to add myself as a user.
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: The database filename can not contain the following 3 characters: [ (open square brace), ] (close square brace) and ' (single quote) " -- end of erro msg.
I have an apostrophe in my last name. Could that be what is causing it? Is it creating a db based on my name or something? Or do I have the wrong version of SQL Server Express installed.
Thank you for any help. I appreciate it.
--Mark
I have Enterprise Manager on my local machine. For the last twelvemonths it has been connecting without problem to my online SQL Serverdatabase provided by my ISP.Three weeks ago the ISP applied some sort of extra securityarrangements to their SQL Server to allow access only through port1433. they have told me to configure an alias using Network Client andto register this alias in the usual way using my Enterprise Manager.My problem is that despite creating the alias in exactly the wayinstructed I just cannot connect to online database. I keep gettingthe SQL Server does not exist or access denied when I try to connect.As a result of advice obtained I have tried using the lite version ofthe 'littleADmin' tool available fromhttp://www.mylittletools.net/scripts/en/mla_sql/Using this useful looking software I find I cannot connect to theonline SQL database when it is installed on my own local machine butif I install it on my website it does connect without problem to myonline SQL. Server databaseHowever I need to use my more powerful Enterprise Manager to connect,my question (at last!) is:1. Is there likely to be a problem trying to connect to my onlinedatabase from Enterprise Manager on my local machine as a result ofthe new security arrangements. In other words, is there somethinganalagous to what is happening with the 'littleAdmin tool' wherebyusing Enterprise Manager I cannot connect from my local machine forsome reason obvious to everyone except myself??or2. Is it possible that there is some problem arising from Net Client?(the aliases appear in Enterprise Manager OK)I know my ISP should be answering this sort of question but they justdon't seem to know. I need to connect even if only to download mydatabase and take it to another ISP,Best wishes, John Morgan
View 4 Replies View Related