A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

learn more… | top users | synonyms

0
votes
4answers
501 views

Log Shipping multiple database SQLServer 2008 Standard

We currently use a fairly basic script we wrote to log ship our databases to our DR site (and back again) but want to move to a better solution. We initially discounted the inbuilt logshipping ...
2
votes
3answers
620 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 ...
1
vote
3answers
1k views

SQL Server instance shuts down

I'm currently developing a new ASP.NET project hosted on a Windows Server 2008 RC2 with an SQL Server 2008 Express database. I have three SQL Server instances (for different purposes) running which ...
1
vote
3answers
405 views

2 Servers setup for redundency, backup

I presently have 1 dedicated virtual server running my website/blog/mail, etc. This is on Hyper-V with 512MB RAM. Windows Web2008. With the VM, I have these running within it: SmarterMail – for ...
0
votes
3answers
48 views

How do I update the SQL Server 2008 to include the studio?

How do I update the SQL Server 2008 to include the studio? Here is what I currently have on my machine: I assume I am supposed to clidk on "SQL Server Installation Center" From there I get this ...
0
votes
3answers
316 views

Unable to connect to local SQL Express (2008)

I'm trying to get an installation of SQL Express 2008 working, but no matter what I do I can't connect to it with management studio. I've enabled TCP/IP for the instance. I've tried connecting with ...
0
votes
3answers
3k views

Disable remote access for one user/database in SQL Server 2008

is this possible to disable remote access for one user or database in SQL Server 2008? Thanks
0
votes
3answers
104 views

SQL Server 2008 hosting (for development)

We are doing distributed development, working at home, office and sometimes at customers. We are using assembla for source-repository and we need a centralized-remote SQL Server 2008 database hosting ...
0
votes
2answers
132 views

Why is it recommended that SQL Server not be run on the domain contoller in an SBS 2008 system?

We are building up our SBS 2008 R2 server and had in mind to put an SQL Server on the same box, same system. First uses of the system are a local file server, VPN for the same purpose, and a central ...
0
votes
2answers
302 views

SQL Server 2008 Express, need to copy a table from one server to another automatically

We have 2 servers with SQL Server 2008 Express for IVR systems and one for our website. The website's database server is more accessible on our network. I would like to copy some tables from the other ...
0
votes
2answers
439 views

Connectivity with SQL Server Express 2008 r2 and SQL Server 2000 on same machine

At first glance this may same a duplicate of Installing both SQL Server 2000 and SQL Server 2008 on the same machine, but it is not. I have SQL Server 2000 and SQL Server 2008 R2 installed on the ...
0
votes
2answers
405 views

Copy SQL Server data from one location to another over the internet

How can I copy certain SQL server data from one server to another without opening direct access to SQL server in the firewall? I thought of things like integration services in combination with an ...
0
votes
2answers
733 views

What is causing intermittent connections problems from web server to sql server 2008 r2?

We have 4 API servers and 2 web servers that connect to a SQL 2008 R2 server. Recently we've noticed that the web servers sometimes can't find the SQL server. This doesn't happen for every connection, ...
0
votes
2answers
515 views

Running sql server 2000 backup file on sql server 2008

I restored sql server 2000 .bak file to sql server 2008 by --RESTORE FILELISTONLY --FROM DISK = 'D:\DBHarshal\full backup august 6.BAK' --ALTER DATABASE EPICSms --SET SINGLE_USER WITH --ROLLBACK ...
0
votes
2answers
182 views

How to install SQL Server 2008 32 bit to Windows 2003 Server 64 bit?

How to install SQL Server 2008 32 bit to Windows 2003 Server 64 bit?
0
votes
2answers
713 views

Is it possible to determine the top users of SqlServer analysis services?

We're trying to figure out how many licenses we need of a desktop data analysis package which connects directly to our SSAS instance. I'd like know if it's possible to query the history of connection ...
-2
votes
2answers
72 views

Uninstall SQL Server

how do I uninstall SQL Server 2008 manually? Add/remove programs does not uninstall everything. Thanks in advance.