SQL 2012 :: Analysis Server Database Disappears After A Reboot
Apr 23, 2015
I do not understand why an SSAS cube disappears after a reboot. We schedule a reboot for our server weekly and after the reboot. I have to deploy my SQL server Analysis Database. It is just gone after a reboot and why this happened. I searched a lot on internet but it seams that I am the only one on this world with this issue.
How I can configure the server in such a way that the SSAS cubes will not disappear after a reboot.
View 2 Replies
ADVERTISEMENT
Sep 21, 2015
I have an issue with Sql Server 2012 and Datastage which extracts the table(just select * from table) and loads into one file without any transformation in between. Source table has around 45million rows. Datastage Process extracts upto 22million rows and then it stalls forever(running state). I had investigated into the Database and i could see the transaction runs on database for some time(runnable and suspended state) for sometime and it disappears suddenly. I am surprised to see Datastage Process still shows rows are being extracted even after transaction is disappears and Datastage process up to 22million rows and then do nothing.
View 3 Replies
View Related
Feb 18, 2013
It is possible to create Analysis Services project (*.dwproj) in Visual Studio 2012 Data Tools?
View 5 Replies
View Related
Jun 17, 2015
I have a few SQL instances on my server (jdjfdijdk)
They where called and organized like this:
MyServer - Database1
MyServer/BBserver - Database2
For some reason instance MyServer/BBserver has stopped and I couldn't make it start so I decided to reboot the server. After reboot the MyServer/BBserver was working but when open the other instance MyServer using Management Studio the Database1 disappear and the Database2 can be accessed by MyServer/BBserver and MyServer instances.
Even a backup made of Database1 and stored at
C:Program Files (x86)Microsoft SQL ServerMSSQL.2MSSQLBackup vanished.
How to recover Database1?
View 19 Replies
View Related
Jul 20, 2005
Is there a method in SQL Server 2k to re-locate the physical databasefiles at the time the server reboots. Currently, the only way I know todo this is by scripting some OS-level commands.Thanks in advance for your help.Amy BoydDatabase AdministratorNetwork Associates*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Apr 20, 2015
I have not used log shipping before and find myself in a position where I need to reboot the secondary node and then the primary node and I don't actually need to failover.
Is there anything I need to be aware of. When rebooting the secondary node I assume the transactions will be held in the primary nodes log till the secondary comes back and just carry on once back up?
When rebooting the primary node nothing needs to be done and the log shipping will just start again once it has come back?
View 3 Replies
View Related
Oct 15, 2004
I seem to recall somewhere that a Microsoft Windows Server (2000 for example) should be rebooted once a week.
Is this an urban myth? If so....I can't seem to find a doc on it.
googled:
microsoft server maintenance reboot schedule recommendation
thoughts?
View 2 Replies
View Related
Jan 25, 2006
I'm very new to SQL Server. I need to reboot the server for some reason. I need your help to list out what a the step that I need to follow to perform this process.
Regards,
Ilmi
View 5 Replies
View Related
Jul 23, 2005
Hello,I have a server running Windows 2000 Advanced and Sql Server. Thesystems runs fine throughout the day but reboots at night, somtimesmultiple times. The event log has a message that reads "The previoussystem shutdown at X:XX PM was unexpected."Any ideas?Paul
View 3 Replies
View Related
Jul 16, 2004
We have to add some hardware and I was wondering if someone could provide a stepwise tip to do it .
It is a 3 Server Environment Pub/Dist/Sub
All three running under SQL2K
Here is what I am planning.
a. Uncheck the Enable in Distributed Agent for each replication
b. Wait for all replications to complete
c. Shut down Publisher ? Or do I have to do something else before that.
Please explain a little .
Thanks
View 2 Replies
View Related
Feb 15, 2008
An IT dept. I have been consulting with has started to reboot SQL server every night. They are saying that this is the best practices. I would like to know if anyone has any other ideas on this subject. What is the best practices for how often a SQL server should be rebooted, daily, weekly, monthly ... ?
Thanks
View 9 Replies
View Related
Jul 20, 2005
I have a client running SQL server 2000 on Windows 2003. Yesterdaydata just started disappearing. It is being accessed by asp via hiswebsite and when the data is being inserted it seems to all of asudden drop all data in the table. Earlier in the day the tabledisappeared all together. Anyone ever see this?LS
View 3 Replies
View Related
May 9, 2007
I have SQL Server 2005 SP1 installed and none of my datasets will retain the mdx expressions but the report will still run
View 2 Replies
View Related
Nov 7, 2002
It takes my server forever to reboot, does anyone know how to fix this or is this a problem with the system or just how it is? Thanks
View 12 Replies
View Related
May 2, 2004
Hi,
I have transactional replication set up between two dedicated servers. Server A is the PDC and Server B is a BDC (they are both Win2000 boxes). Both the servers are brand new, and replaced the two that were running like clock work (replication wise) for the last 12 months. I never had this problem with the old servers....
When the servers are shut down (as the case was a couple of weeks back with a power failure) or just recently when they were move to another room. Both servers boot up at the same time. Server B (which is the server holding the db being replicated) boots quicker and as a result replication fails and is then 'sucessfully stopped'. Unless I am aware of the server being rebooted and can monitor this potential problem, within 2 days the logfile grows to large and everything comes to a crashing halt.
I just remove replication, truncate and shrink the log, reset replication and we're away.... BUT I really need to know why it is happening in the first place. I figure there must be a setting that I have forgotten about or something.
Both servers are Win2000 (SP4) and SQL2000(SP3a).
Any help would be appreciated.
Thanks
Casper
View 3 Replies
View Related
Feb 28, 2007
is there a way to find out when the sql server was last rebooted (or how long its been up) in tsql or command prompt (which I will take into tsql)
ta
View 7 Replies
View Related
Jul 23, 2005
To All,I have a SQL2KSP3a database(<1GB) running on a 4x3GB physical CPU with4GB of ram. It is Windows Server 2003 with hyper-threading turn on.There are ~420 .Net users/cxns (fat client, no web/app servers) withconnection pooling and ~1 trx/sec. The database growth is neglegeableand actually is not even relevent which I will explain in a minute.99% of the trxs are from one SP that does a select. The resultsets arerelatively small as well 1~100 rows. Yes I have tuned it with indextuning wizard as well, changed the SQL memory configurations, etc....My problem is this...The first day after a reboot, the server runs 6%CPU during peak hours.During the non-peak hours until the next day something apparentlyhappens. The next day (2nd day after a reboot), it jumps to 40%CPUduring peak hours. The server will continue to run at 40%CPU duringpeak hours until the next reboot. This phenomenon has been occurringfor 6 months or more and the traffic on the server is the same for day1 as it is for day 2,3,4,... This database was on another server with100+ dbs and exibited the same behavior, thus bringing that server toits knees, and thus we had to move it to the server in question with noother dbs.I have googled my eyes out, Microsoft site, white papers, perfmon,SQLDiag, PSSDiag, execution plans, index tuning wizard, and the listgoes on! I currently have a case open with Microsoft that has beenopen for months now. I have been passed around to the 3rd "MS TechSpecialist". I have ran PSSDiag a total of 6 times for them for hourson end. I have changed MAXDOP. I could give more information, but Iwould be here for days. I am running out of patience/ideas andMicrosoft is apparently blowing smoke.Any ideas are greatly appreciated!Thanks in advance!JL
View 10 Replies
View Related
Jun 11, 2007
If I am running SQL Server 2005 in a clustered environment, what is the safest way to restart the SQL server agent? It is currently running but I need to restart it for maintenance purposes.
Is the safeway way to restart is to login to the SQL Server Management Studio as the system administrator, select the SQL Server Agent object, right-mouse click and select "Restart?"
View 2 Replies
View Related
May 10, 2007
How many times per year should we schedule time to reboot a SQL Server 2005 Cluster? We want to do this to defrag the memory. What I am looking for is a document from Microsoft or a consulting firm that has a good reputation that I can show my manager.
View 7 Replies
View Related
Oct 16, 2015
I am searching for a Powershell script which picks Windows Server names from SQL server table(eg: Instance.DB.tbServerList) & writes last reboot date to SQL server table(can be same or different table).
View 6 Replies
View Related
Feb 22, 2005
Hi Everyone,
We have an Analysis Services database which has 9 cubes. Whenever I do an Archive/Restore it fails giving the following error:
* Unexpected error encountered while updating repository item cannot be found in the collection corresponding to the requested name or ordinal.
* Restoration Cancelled
* DSO function failed
Please advise.
Regards,
Kalyan
View 1 Replies
View Related
Sep 19, 2007
Sorry i think i may have posted this in the incorrect forum before - if i have done it again here can someone tell me where i should post this please, thanks:
Hi,
we are having problems with a server Intel RZeon 3ghz, 3gb ram running 2003 service pack 2 with a 70gb drive and and 400 gb drive all with adequate free space. There are 6 hard disks in total and i assume operating at least RAID 5. We have SQL2000 server with a few standard sized databases and a connection to one other server.
A few months ago the back up of SQL server databases started taking 4- 5 hours when before it took 20 minutes. We had actually lost one of our disks in the RAID array and it before this was spotted by our engineers we reindexed the sql databases and defragged both 70gbC: and D: 400gb drives hoping to correct this slow down. Unfortunately the new disk had not been correctly seated and this was why it was taking 4-5 hours. After fixing the disk the backups took 12 minutes again but then started taking 2-3 hours after a few days.
The reindex/defrag did seem to improve the speed of the backups to 12 minutes (from 20 minutes) when the backup did function correctly (also the sql databases' performance improved). However the backups only take 12 minutes after a server reboot - this can last from only 2, up to 5 backups(days) in a row before a slow down to 2-3 hours and again only a reboot will sort out this problem.
NB this intermittent slowdown only occurred after the disk failure.
We have tried monitoring SQL server and can find no CPU/RAM intensive clashes or long running jobs interferring with the back up. Does anyone know what might be going on here? and if there are any server monitoring tools that may help us discover what is causing this problem ?
thanks for your help
best regards
kevin
View 11 Replies
View Related
Sep 5, 2001
how autorestart sql prifile trace after NT server reboot or or after shotdown and restart of Sql server ?
thanks
View 1 Replies
View Related
Feb 20, 1999
I have a situation that I was wondering if anyone has ever ran into before. It has to do with one of my MS SQL servers. The hardware is a ALR/Gateway 9000R with 4 PP200's, 1 Gb RAM, and a RAID 5 with 72 Gb storage. The NIC card is an ATM 155 Mbit card connected directly to our fiber backbone.
I have WinNT 4.0 Server Enterprise Edition loaded with SP4 and MS SQL Server 6.5 Enterprise Edition with SP5 installed.
I have 7 seperate active databases on the server supporting 7 different applications. The server has been on-line for approximately 4 weeks and just recently (last Thursday) it has started to "lock up" every couple of days. By lockup I mean that it starts to reject all requests by all users. No one can connect to the server including myself. The MS SQL error log grows and grows until we reboot the server. The error logs are 100 Mb or larger in size due to rejection errors being repeated over and over again.
There has been no change made to the server since initial installation.
The error in the MS SQL error log that keeps on being repeated is...
"Message 17308: Kernelerror - Lazywriter. Process (process ID number) generated access violation; SQL Server is terminating this process."
We have an incident in with Microsoft but they are not responding fast enough.
I was hoping that someone out there may have had this type of occurrance happen before.
Any suggestions?
Jim
View 1 Replies
View Related
Jul 20, 2005
Hi All,I have a SQL Server 7 installation running on a windows 2000 server.SQL Server switches from mixed mode authentication to Windows Only onreboot. Has anyone else experienced this? Any help would be greatlyappreciated.Service Pack Reports:Microsoft SQL Server 7.00 - 7.00.1077 (Intel X86) Sep 6 200215:10:15 Copyright (c) 1988-2002 Microsoft Corporation StandardEdition on Windows NT 5.0 (Build 2195: Service Pack 3)I only see two strange entries in the log:2004-05-01 00:38:09.55 spid37 Using 'xpsqlbot.dll' version'1998.11.13' to execute extended stored procedure 'xp_qv'.2004-05-01 00:38:01.71 spid1 Failed to obtainTransactionDispenserInterface: Result Code = 0x8004d01bI don't believe that either of these are related to the configurationoption for Windows Only, though.
View 2 Replies
View Related
Aug 22, 2007
This computer gets set to autostart the SQL Server Service, which is set to local, (have also tried local network and user specific), and everything works fine. But when it gets rebooted, the service refuses to start.
We disabled the Mcafee and Windows firewall. No effect.
The SQL Browser and Full Text Index Services start automatically just fine.
Anyone have any experience with this?
Thanks,
Pat
View 3 Replies
View Related
Jul 18, 2006
Running Package disappears without a trace.
It appears to be failing silently. It does not produce an OnError or OnTaskFailed message in the sysdtslog90 table.
The events I am logging are:
OnError
OnExecStatusChanged
OnPipelinePostEndOfRowset
OnPostExecute
OnPreExecute
OnProgress
OnQueryCancel
OnTaskFailed
The package gets executed from a web application which launches it in a new thread like this:
Package pkg;
... <Sets up pkg object>
private void RunPackage()
{
ThreadStart threadStart = new ThreadStart(PackageExecute);
Thread thread = new Thread(threadStart);
thread.Name = pkg.Name;
thread.Start();
}
private void PackageExecute()
{
try
{
pkg.Execute();
}
catch (Exception ex)
{
lblMessage.Visible = true;
lblMessage.CssClass = "ErrorMessage";
lblMessage.Text = ex.Message;
}
}
I see the PackageStart in the log and it sucessfully executes the first few tasks and then the last entry in the log is:
OnPreExecute (source=SQL Delete task, datacode=0)
Any ideas how I can troubleshoot this? I checked the event viewer on the server and it showed the Package started but that is all.
I also checked the running packages node of the Integration Services server and there was no running package.
I have SP1 installed.
Thanks.
View 5 Replies
View Related
Apr 16, 2015
I'm performing an upgrade of a DW Warehouse Server from SQL Server 2008 to another machine with SQL Server 2014.I know that you can perform the restore via the SSMS GUI but I want to script it out.URL....
View 4 Replies
View Related
Jun 3, 2002
Hello,
SQL Server 2000 services getting stoped automatically when system get reboot. When system reboot they started and after 5 minutes they were getting stoped.
I went through the event log file and found that an error is occuring in sql server with number 17148.
And I also observed that there is a file called "C : P r o g r a m F i l e s V E R I T A S B a c k u p E x e c N T b e n g i n e . e x e" is executing during the maintenance process,which is stopping the sql server services(agent and olap)
This problem is generating error in sql server with above mentioned number.
regards,
vnk.
View 1 Replies
View Related
Nov 9, 2007
Hi I've got a sql server 2000 database that when running is runnign fine. About 9 months ago I altered one of the stored procedures and ever since then when the machine is rebooted the stored procedure is "reverted" back to the old sproc... ???
is there any way I can recrete a sproc in a job that runs every day?? why would it be doing this?
View 1 Replies
View Related
Jul 13, 2001
From time to time, history info on our scheduled jobs (SQL Server 7.0) is missing. When I try to view job history, I get a popup saying "There is no history information for this job". Sometimes the job does run, however, sometimes it doesn't... The problem seems to happen randomly on random scheduled jobs. Any tips on how to get back the consistency of info we used to enjoy in 6.5?
Also, is there a way to specify how many job runs the history should display. It only goes as far as 5 or so, I wonder if it can capture more "runs"?
Please email back the answer to lpinskaya@firstam.com - it would be GREATLY appreciated.
View 2 Replies
View Related
Mar 27, 2008
All,
I am using the Oracle Provider for OLE DB (32 bit) to connect to an Oracle 10g database. I enter all the connection parameters and test the data source and I it says that the connection is successful. I then open the connection manager for the data source and see that the password has disappeared.
After reading entries on this forum, I tried to setting the package permission to UserKey, Password and others. Still no luck. Then I created an XML configuration file and set the connection string and password there as well. Still no luck.
Below is the message I am getting:
Error: 0xC0202009 at Package1, Connection manager "******": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Error: 0xC00291EC at Execute SQL Task, Execute SQL Task: Failed to acquire connection "****". Connection may not be configured correctly or you may not have the right permissions on this connection.
Here is my XML config file:
- <DTSConfiguration>
- <DTSConfigurationHeading>
<DTSConfigurationFileInfo GeneratedBy="******" GeneratedFromPackageName="Package1" GeneratedFromPackageID="{63C53905-74EC-4AD5-9523-3A4B4BEF4CB5}" GeneratedDate="3/27/2008 8:39:47 AM" />
</DTSConfigurationHeading>
- <Configuration ConfiguredType="Property" Path="Package.Connections[*********].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>Data Source=*****;User ID=*****;Password=******;Provider=OraOLEDB.Oracle.1;Persist Security Info=True;</ConfiguredValue>
</Configuration>
- <Configuration ConfiguredType="Property" Path="Package.Connections[*****].Properties[Description]" ValueType="String">
<ConfiguredValue />
</Configuration>
- <Configuration ConfiguredType="Property" Path="Package.Connections[*******].Properties[InitialCatalog]" ValueType="String">
<ConfiguredValue />
</Configuration>
- <Configuration ConfiguredType="Property" Path="Package.Connections[*******].Properties[Name]" ValueType="String">
<ConfiguredValue>******</ConfiguredValue>
</Configuration>
- <Configuration ConfiguredType="Property" Path="Package.Connections[*******].Properties[Password]" ValueType="String">
<ConfiguredValue>******</ConfiguredValue>
</Configuration>
- <Configuration ConfiguredType="Property" Path="Package.Connections[******].Properties[ProtectionLevel]" ValueType="Int32">
<ConfiguredValue>1</ConfiguredValue>
</Configuration>
- <Configuration ConfiguredType="Property" Path="Package.Connections[********].Properties[RetainSameConnection]" ValueType="Boolean">
<ConfiguredValue>0</ConfiguredValue>
</Configuration>
- <Configuration ConfiguredType="Property" Path="Package.Connections[*******].Properties[ServerName]" ValueType="String">
<ConfiguredValue>******</ConfiguredValue>
</Configuration>
- <Configuration ConfiguredType="Property" Path="Package.Connections[********].Properties[UserName]" ValueType="String">
<ConfiguredValue>*******</ConfiguredValue>
</Configuration>
</DTSConfiguration>
I am a local administrator on the box as well. Any help would be greatly appreciated.
View 10 Replies
View Related
Mar 16, 2015
Any command through that can I delete/disable the DWORD value "Pendingfilerename operations" so that while I start the SQL Install work, it does not fail due to this and can write this as one of the precheck options.
View 0 Replies
View Related
