0
votes
0answers
37 views

SQL DATABASE USING VPN

I have a very simple classic asp site on a Windows 2008 Server with an IIS 7.5 that connects to an Sql database on a Sql 2008 r2. the site works perfectly when accessing it both locally from the ...
0
votes
0answers
41 views

Removing Orphaned user from MS SQL Server 2008 database fails

I am dealing with an issue where a User is not able to logon with the database Username & Password all of a sudden. In the past I have reported orphaned users by running these 2 commands: USE ...
0
votes
1answer
84 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 ...
0
votes
2answers
78 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
97 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 ...
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 ...
0
votes
1answer
73 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 ...
2
votes
1answer
61 views

Copy a database from Denali CPT3 to SQL 2008 R2

Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a ...
1
vote
1answer
160 views

SQL Server 2008 Snapshot Replication Trigger Start

I have setup a production server and a staging server. Whenever we are at the point in our release cycle where we want to begin testing on staging I want to copy the production DB over to our staging ...
0
votes
1answer
105 views

2 VMs with Win Server 08 - how to ping/connect to a DB?

In the past, I always installed SQL Server on the same machine as the server application that would be using it. Now for the first time I need to install a MS SQL Server 2008 R2 DB instance on a ...
6
votes
5answers
523 views

Virtualizing Microsoft SQL Database server

My company is looking to virtualize our Microsoft SQL server. I read on another question that databases on VM's suffer from a IO bottleneck which is not very good for us. But I was wondering if ...
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, ...
1
vote
1answer
6k views

CREATE DATABASE permission denied in database 'master' … A database with the same name exists, or specified file

Background: I'm trying to get the Live Demos of Telerik's Rad Controls for ASP.NET AJAX working on my local machine in IIS 7. I'm getting an error when I view the ComboBox demo. Error I get: ...
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
38 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.
0
votes
2answers
427 views

SQL Server 2008 - Changing Identity increment of a primary key in a table

I am changing the increment (making it 2 instead of 1) in identity of a column. SQL Server giving me the following error while making change to DB. I searched on internet but some of people saying ...
1
vote
2answers
405 views

SQL Server Express - Move by Copying Data Folder?

We are moving our SQL Server to new hardware. Initially we were going to do this simply via backup and restore, but noticed we'd have to recreate all the logins. We don't want to do that :) ...
2
votes
4answers
12k views

The database myDb is not accessible. (ObjectExplorer)

I'm developing an ASP.NET MVC3 web app, which connects to a SQL Server 2008 R2 database. Everything was working fine, until I started getting this error: The database myDb is not accessible. ...
3
votes
1answer
200 views

How do I remove an old SQL Server 2008 Express Database Instance

I am trying to restore a database over the existing one. This worked fine in the past, until all of a sudden, it doesnt. I have clearly, in the past, attached the same database file under a different ...
0
votes
2answers
631 views

SQL Server 2008 database Backup

today I was trying to restore a database with a backup I had made previously on another computer, however I kept getting the following error message: the media loaded on "filepath" is formatted to ...
0
votes
3answers
372 views

Why is my empty SQL 2008 database so big?

I have a database I wanted to deploy with my application. So I emptied it, but the size is still HUGE! Even after running DBCC SHRINKFILE (1, 1) and DBCC SHRINKDATABASE (1, 1) Can anyone help?
0
votes
1answer
498 views

SQL Server 2008 Error when restoring DB backup: “specified cast is not available”

I was using SSMS to restore a database backup onto another database in a SQL Server 2008 instance, when I received the error message: "specified cast is not available". The backup was made on a SQL ...
0
votes
2answers
126 views

How do I create a free server-side database to be accessed via Windows forms and/or browser?

I have no formal education in databasing or programming, but I've learned enough SQL, C++, and C# to at least get started setting up a small database on my company's server. Using MS SQL Server 2008 ...
0
votes
1answer
347 views

Does multiple files in SQL Server when using RAID help reduce conflicts in growth and file-locking?

I've been reading around and get the impression that if you are using RAID then using multiple SQL Server files within a filegroup won't yeild any more improvements, and the benefits are purely ...
1
vote
2answers
312 views

SQL Server: Filegrowth options for Data Warehouse database?

I'm creating a database for data warehousing purposes. The database will grow about 10 000 - 100 000 rows in a week (this is a guess). I think that I'll have to go with database file autogrowth, what ...
3
votes
2answers
1k views

repair suspect database

My sql server 2008 told me that you database is suspect and I can't see my tables or my data or use it what should I do ?
0
votes
2answers
108 views

repair database [duplicate]

Possible Duplicate: repair suspect database my sql server 2008 told me that you database is suspect and I can't see my tables or my data what should I do ?
0
votes
1answer
244 views

What is a “DataBase Server Load”?

we are running sql server 2008 (not R2). 64 bit machine/operating system - 32 gig memory. The hardware/system guys are using Orion, I use Idera to monitory system vitals. Orion refers to "Physical ...
10
votes
1answer
17k views

What can user do with VIEW SERVER STATE permissions?

In SQL Server 2008 there is a permissions VIEW SERVER STATE. What rights this permission give to user? What SQL Server mean by SERVER STATE?
0
votes
1answer
660 views

SQL Server MDF Files Split guidelines

Are there any specific guidelines to split up a single MDF file into multiple files for a single database. An example of a scheme that I can think of is splitting it so that one NDF file contains just ...
8
votes
2answers
4k views

How to Link an SQL Server 2008 Server to an SQLite Server?

I want to "Link" an SQLite server with an SQL Server 2008 server. E.g. using the sp_addlinkedserver command. How do I do this? I have searched far and wide, but found no solution for this problem. ...
0
votes
3answers
2k views

sp_msforeachdb does not list all databases on a SQL Server instance

I'm using sp_msforeachdb to list all databases on my server. I know it is unsupported, but I wonder why it does not list all the databases I have installed. This is how I run it: set run="C:\Program ...
1
vote
3answers
679 views

SQL Server 2008 - Secure remote access

I wish to allow remote access to an SQL Server database from a Microsoft Access database to allow my client to build reports as and when they wish. I can do this without any issue by opening the ...
10
votes
5answers
11k views

Should I install 32-bit database or 64-bit database?

(I've read a lot about 64-bit versus 32-bit OS/Apps, but this question is specifically in regards to databases.) I'm trying to understand the pros and cons of 32-bit versus 64-bit databases, and ...
0
votes
2answers
438 views

How to encrypt data at rest

How can you encrypt data at rest on Sql Server Web Edition? TDE is apparently not an option, but I don't know what else is available. Any recommendations?
0
votes
3answers
724 views

SQL Server: Log file grows more and more, and do not get merged with the MDF file

My database files look very suspicious. we are using the DB in a production stage. and I'm seeing how the LDF file grows more and more. while the MDF file seems as it is not growing at all (I don't ...
2
votes
1answer
25 views

How to ensure dbs are all in sync when restored?

In large server environments, how do you handle the issue of backing up SQL Server dbs which may not be in sync with other dbs they rely on? So if I back up DB1 from a server, and it uses another db ...
1
vote
2answers
770 views

SQL Server 2005 to 2008 DB attach elp please!

I have SQL Server 2005 Standard on my personal machine. I created a very big DB about 21 gb. I made a backup and transferred the .bak file via an ftp program to my dedicated server. I have SQL Server ...
2
votes
1answer
652 views

SQL Server 2008 Unique Problem for bring DB Online

This is my error I am facing TITLE: Microsoft.SqlServer.Smo Set offline failed for Database 'Go3D_Retailer ------------------------------ ADDITIONAL INFORMATION: An exception ...
1
vote
2answers
792 views

multiple VM vs multiple named instance

I am looking for some comparison or data for sql 2008 deployment , what are the advantages and disadvantages installing multiple VM vs multiple named instance ? How can i save license cost using VMs ...
2
votes
3answers
562 views

SQL 2008 - db mail issue

I have two instances of SQL Server 2008. One was upgraded from SQL Server 2000 and one was a clean, new install. The instances are running on different nodes of the same cluster, although I have ...
0
votes
2answers
3k views

Import database: SQL Server 2005 Express to SQL Server 2008 Enterprise

I have two servers 1 x SQL Server 2005 Express and 1 x SQL Server 2008 Enterprise How can I move/import my database from SQL Server 2005 Express to SQL Server 2008 Enterprise? (BACKUP SQL SERVER ...
2
votes
2answers
4k views

SQL Default Instance Name

Can the default instance name be something other than (local) or (machinename)? For example, if my server is called Apple, and I install SQL Server 2008 and choose to create a default instance and ...
1
vote
2answers
1k views

How to connect to local instance of SQL Server 2008 Express

I just installed SQL Server 2008 Express on my windows 7 machine. I previously had 2005 on here and used it just fine with the old SQL Server Management Studio Express. I was able to connect with no ...
2
votes
0answers
91 views

How to do Merge Replication?

I tried to do synchronization of database between servers to synchronize a database using merge replication. Simply I've added publication in server A and subscription in Server B by declaring ...
4
votes
1answer
803 views

SQL Server Developer Edition versus SQL Server Standard

not sure I understand this but I am going to throw my assumption out there: SQL Server 2008 Standard & Enterprises editions are for running full database services on server (not just but for ...
1
vote
2answers
1k views

Detaching a Microsoft SQL 32bit database and attaching it to a 64bit server

I want to detach a database from a 32bit Microsoft SQL 2005 environment and attach it to a 64bit Microsoft SQL 2008 environment. Microsoft says: The SQL Server on-disk storage format is the ...
1
vote
2answers
2k views

How does a SQL database handle simultaneous requests?

This may be a bit of a noob question, but I'm curious: How can a database handle multiple simultaneous requests, most notably reads? Is every request placed in a queue, so it really occurs one at a ...
5
votes
5answers
10k views

Would the database compatibility level affect performance?

We just migrated our Microsoft SQL Server from 2005 enterprise to 2008 standard on the same specification hardware. The databases were backed up and then restored to a clean sql 2008 install. The ...
2
votes
5answers
1k views

How to install SQL Server 2000, SQL Server 2005 and SQL Server 2008 on a single machine

I'm in the process of migrating development databases from an old (soon to be decommissioned) database server to a VMWare-hosted virtual machine running Windows 2008 x64. The old server runs SQL ...