-1
votes
1answer
50 views

Will an average PC run a 10 concurrent write intensive request with 50MB daily database server? [on hold]

As I am a average programmer who have never been purchasing any hardware myself, I have to choose a computer for a prototype database server that will be used to serve 10 concurrent request per one ...
0
votes
1answer
37 views

Should I move to an Azure database? [on hold]

I am currently using a database from an installed instance on my web server in a VM on Azure. I was thinking about moving it to an actual Azure Database so I could load balance the web server. Does ...
0
votes
1answer
30 views

Microsoft SQL Server Standard High Availability without Shared Storage

I'm a software dev with little experience managing SQL so please bear with me! We are developing a piece of software that needs to be highly available, with a significant degree of resilience. This ...
-1
votes
1answer
51 views

Cannot access my database, it says database inaccessible

I am hositng my application on a server but runs my Sql server in windows mode as application is still bieng developed. But suddenly when today I opened my Sql Management Studio, it is not allowing me ...
0
votes
0answers
206 views

MySQL Workbench Could not connect to Source DBMS

I have a server which has a MSSQL database and i trying to data migrate from MSSQL to MySQL, in the first stop after i choose database --> data migrate --> i choose data system (Microsoft SQL server) ...
1
vote
1answer
132 views

How export database from mssql by using command line

I am using windows7 os and i have a database on MSSQL server 2005 i am using following codes to import database sqlcmd -S [server instance name] -d [database name] -i [filename you want to import] ...
1
vote
1answer
22 views

Error in cross server sqlcmd execution due to firewall issue

I have an application server with an IP of 10.107.0.100 and one database server on which SQL Server 2012 is installed, with an IP of 10.107.0.101. Remote connections are made to this server, and the ...
0
votes
1answer
56 views

MSSQL: Restore a DB to the latest file in a backup set

I have a MSSQL 2008R2 DB in SIMPLE recovery mode that is periodically backed up with BACKUP DATABASE MyDB to DISK = 'Z:\MyDB.cbak' WITH COMPRESSION This runs periodically, creating multiple ...
0
votes
1answer
71 views

Is an ms-sql/excel connection two way?

When I connect to an external data source on my MS-SQL server using Excel, is it solely an import, or can I edit the data residing on the MS-SQL server right from Excel? I have a user (the DBA, funny ...
1
vote
1answer
56 views

Does converting a disk from basic to dynamic require a reboot?

I'm finding conflicting info on converting a disk from basic to dynamic and have a few questions. Will it require a reboot? The server with the disk in question is hosting SQL Server 2008 R2, and ...
1
vote
2answers
320 views

Can remote queries cause locks?

We have a SQL Server 2005 (SERVER-A) server that holds the database for an application that has been locking a lot lately. We suspect that the problem are transaction locks, so we decided to capture ...
0
votes
2answers
76 views

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
1
vote
1answer
89 views

Cannot Connect to MsSql2008 R2 Database Engine, While Connecting to Other Services

I have installed MsSQL 2008 R2 on my computer as I have installed always before. But unfortunately this time, I cannot connect to Database Engine while I can easily connect to the other services like ...
0
votes
2answers
56 views

Recommended Setup

I have been running into issue with my MSSQL Database setup with speed. Here is my scenario. About 100M Rows Average: 1k Updates Per Second Hard Drives: RAID 10 SSD MDF --Active Time: 0 Log ...
0
votes
1answer
100 views

how to copy sql server database on same server

I've got a SQL Server 2008 and want to make a copy of a database so I've got a 2nd Version of the database for testing on the same server. The database copy wizard is not able to copy the database, ...
-1
votes
1answer
32 views

Why is SQL Server seperate from the roles in Windows Server 2008 Server Manager?

I have an instance of Windows Server 2008 running on my machine. Within the OS there is a useful application called Server Manager, where I can manage several roles for my machine (such as web server, ...
1
vote
2answers
777 views

Weird behavior using Active Directory group mapped to SQL Server user/login

I've run across a very odd behavior on SQL Server 2008R2. I have a third-party application which acts as a SQL Server client. I have a subset of my users who should have access to this application. ...
2
votes
1answer
75 views

What does -fixcolnames do in log parser 2.2?

I'm using Logparser 2.2 to try to bring a .csv filled with Performance Counter information into a SQL database, and I'm using the following command line command: logparser "Select * into IISCounters ...
0
votes
1answer
589 views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
3
votes
3answers
558 views

if I select more than 15 fields, I get catastrophic failure

Using sql server 2012 I am connecting to a linked server with Pervasive SQL on it. When I do select * or select field1,field2,field3....field15 I am getting this error: Msg 7399, Level 16, State 1, ...
0
votes
2answers
133 views

Coverting MySQL SQL statements to SQL Server

I am installing a product which needs a database - it can use any database as long as there is a jdbc connector available for it. However, the installation guide has instructions only on how to make ...
-2
votes
1answer
156 views

Database synchronization [closed]

What is the most efficient way to sync/mirror certain data from a large remote database with a local version? The scenario is, there is a central remote database on a hosted server, which will share ...
0
votes
1answer
324 views

What are invalid table names in SQLServer?

So, apparently you can't name a table Trigger in SQLServer. Someone in my office found out the hard way porting an application from MySQL, I'm suspicious of whether or not that's a valid table name in ...
1
vote
1answer
2k views

Unable to start SQL Server Instance 2008 R2 - DB file corrupt

I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is " The log scan number passed to log scan in database ‘master’ is not valid. This ...
1
vote
1answer
206 views

Database backup with T-SQL script - Issue with Declare and Set Variables

Can someone tell me why I can't backup my database with the script below? I can run the script but it didn't create the backup. I"m using SQL Server 2008 DECLARE @pathName NVARCHAR(512) SET @pathName ...
0
votes
1answer
163 views

MSSQL Incremental Database-to-Database backup/clone

I'm trying to save some time on a repeated task I keep getting asked to do. We have an internal application we'll call "App". This App has a database called "AppLive" We have a "Test" instance of ...
0
votes
0answers
134 views

cannot connect to ssms local database windows7

i am running SQL Server 2012 Management Studio Express in windows 7, i am having issues connecting to the local db. i tried all the above mentioned solutions, didnt work. please help. thanks in ...
0
votes
2answers
1k views

Cannot access local database with IIS Manager

I've created a local .mdf database with Visual Studio 2010 and did a couple of modifications to it. Now I want to edit it in IIS Manager. However, I cannot access it neither by connection string, nor ...
1
vote
1answer
116 views

Java Tomcat SQL 2005 connection failed

I am in a bit of strange situation when it comes to debugging this issue. I am working with a client who has a 3rd party administrate their servers, and that 3rd party does not allow for any changes ...
1
vote
1answer
50 views

Are Microsoft Azure SQL Federation services covered by the SQL Azure SLA, or is it currently in CTP?

I can't seem to find a definitive answer for this. Are the new SQL Azure Federated Database features covered by the SQL Azure SLA? Or are these features still considered to be in CTP?
0
votes
1answer
72 views

Steps to recreate SQL Server Instance

I'm writing a disaster recovery protocol at work - a protocol that describes how to create a SQL Server instance from scratch in case that the PROD server will be unavailable. We have SQL Server 2008 ...
0
votes
1answer
58 views

Index Proposals

As a theoretical database question, if you are asked 'which indexes would you propose and why?' are the answers from primary, clustering and secondary index? How would we know if we should introduce ...
2
votes
1answer
212 views

Define priority of database access into SQL Server 2008

We're using a sql Server 2008 database. This database provides data for two main applications : 1) A website to display a Viewer. 2) A routing application that needs to be highly responsive ! Is it ...
1
vote
2answers
350 views

SQL Server architecture - they want to move my database to new instance…Why?

Our current production database environment contains about 10 similarily managed databases. Our agency has just purchased and is installing new blade chasses and wants to move my database to a new ...
1
vote
2answers
505 views

Possible to regularly export MS-SQL tables to another DB format on Linux without complete dumps?

We have a production server running SQL-Server, which holds our backend data, e.g., customer information, sales invoices etc. The nature of this data is that "old" data can change, e.g., a customer ...
0
votes
0answers
129 views

inLoox is unable to connect to SQL Server

I just installed InLoox and configured a connection to our MS SQL Server 2005. The connection should be fine - telnet works and I can connect to the inLoox database with my query analyzer. My ...
-1
votes
1answer
202 views

How Do I Configure SQL Server 2005 Backend? [closed]

I am trying to develop an inventory/payroll system for a factory. The information will be stored on a server, Windows Server 2008 R2, and SQL Server 2005. I'm going to store the records on the server, ...
0
votes
1answer
316 views

how to decompress a local drive? [closed]

I have local drive in my system. The file system in my drive is NTFS. Some days ago I compressed my drive by disk cleanup for releasing free space. But when I want to attached my sql database with ...
0
votes
1answer
93 views

MS SQL Server not running on Win7

I have installed all of the available components of "MS_SQL_05" as a named instance on Win-7. I had a default instance running of MSSQL08. While installing the MSSQL05 instance I choose to use windows ...
0
votes
1answer
157 views

Dedicated database server or local database server for performance

We have a dedicated server that contains 3 virtual server with iis 7.5 on it. There are 50 real ip addresses pointing to the server, with some of them assigned to the virtual servers. I wasn't sure ...
0
votes
1answer
149 views

using command line to extract large db file

I have a large database file (1.5GB) named file.sql, I use "source" command to extract it into mysql databse but I receive lots of error messages. It used to work fine. Here is a snapshot of part of ...
2
votes
1answer
554 views

How to Configure SQL Server 2008 R2 Log Shipping

I need to set up a standby server using SQL Server Log Shipping. This is my first time doing this, so I'm following the instructions in the SQL Help step by step. Of course, I ran into a problem at ...
0
votes
1answer
67 views

Performance analytics via DBMS “plugins”, or other solution

I'm working on a systems monitoring product that currently focuses on performance at the system level. We're expanding out to monitoring database systems. Right now we can fetch simple performance ...
0
votes
3answers
76 views

How to warehouse data that is not needed from MS SQL server

I have been asked to truncate a large table in MS SQL Server 2008. The data is not needed but might be needed once every two years. It will NEVER have to be changed, only viewed. The question is, ...
4
votes
1answer
109 views

SQL Server 2008 R2 - What is the best plan to back up 2005 dbs and move to new 2008 machine?

I have four super small databases that I need to migrate from SQL Server 2005 on one box and move to a brand new SQL Server 2008 R2 box. I have backed up the databases and copied them to the new ...
1
vote
1answer
633 views

Unexplained CPU and Disk activity spikes in SQL Server 2005

Before I pose my question, please allow me to describe the situation. I have a database server, with a number of tables. Two of the biggest tables contain over 800k rows each. The majority of rows ...
0
votes
1answer
507 views

Error 5070 when deleting Microsoft SQL Server database

I have recently relocated a database and need to delete any existence of the old database. Since I want to completely remove it, I am simply opening up SQL Server Enterprise Manager, finding the ...
0
votes
1answer
853 views

get a sql server 2000 database out of emergency mode

there is a db in emergency mode,which i was told to make it "normal". in the enterprise manager i can not see any objects(like tables, users and stuff). in the guy's computer, i connect to the server ...
2
votes
2answers
251 views

Is it considered a bad idea to have a publicly facing MySQL or SQLServer Database?

If I wanted to create a publicly facing database for purposes of connecting it to a client MS Word or Open Office Writer installation, would this be considered a dangerous security practice? What if ...
54
votes
7answers
5k views

What are the drawbacks of running a database inside a virtual machine? How do I overcome them? [closed]

Running anything inside a virtual machine will have some level of performance hit, but how much does it really impact the performance of a database system? I found this academic reference paper with ...