-1
votes
1answer
37 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
94 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
61 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
18 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
44 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
53 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
46 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
283 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
72 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
78 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
83 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
541 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
69 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
437 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
489 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
123 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
141 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
289 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 ...
0
votes
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
192 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
158 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
129 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
114 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
49 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
70 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
181 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
344 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
470 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
121 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
195 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
299 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
153 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
148 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
487 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
108 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
611 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
479 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
770 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
237 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 ...
3
votes
1answer
261 views

sql server limitation of data size

This question is related to my SQL Data type size A varchar(max) seems to be able to store up to 2GB. What I can not understand though is that in this link sql row overflow MS says (my emphasis): ...
0
votes
4answers
2k views

Database planning - Multiple Schemas vs Multiple Databases vs Single large database vs Partitions

We design websites for Realty companies. The websites are used only to display the information and all the websites share a common template. We have around 150 websites for different customers. Some ...
1
vote
1answer
37 views

Why does it appears this error when I install SQL Server 2008?

It appears that "Performance counter registry hive consistency has failed". What's the cause of that error? And how can I resolve it? Thanks in advance.