0
votes
1answer
46 views

Sql Server Transaction Log Backup Fails

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
6
votes
1answer
69 views

Copy SQL Server Databases

I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB. I've seen and even used some of the various data ...
-1
votes
2answers
722 views

Can there be two machines with the same server name (SQL SERVER) in the same network? [closed]

I have a program in excel that connects to several sql servers using servername and instance. My question is, what would happen if there are two servers (machines) with the same servername in the same ...
0
votes
1answer
85 views

How to best move system DBs from SQL 2005 to SQL 2008 R2?

I'm in the process of moving from SQL 2005 to SQL 2008 R2. Moving the production DBs and logs is straightforward, through either detach/attach or backup/restore. (new hardware, so I have the old ...
1
vote
0answers
72 views

SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express Edition

I've installed SQL Server 2008 R2 Express Edition in my Win 7 notebook. The Express Edition doesn't have SQL Profiler enabled. Thus it's hard for me to debug my SQL 2005 applications. I have a ...
1
vote
1answer
304 views

What's the importance of restoring SQL Server system databases (model, master, etc.)?

I had to restore some production databases to a different drive on the same Microsoft SQL Server 2005 machine. That worked fine and the application using the databases is back online. However, i have ...
0
votes
1answer
79 views

SQL Server 2005 connection to SQL Server 2008 R2

I having trouble with SQL Server 2008 R2 Express. I installed it and the service is running but SQLexpress, but without success. I even tired to uninstall SQL Server 2008 R2 and I could it said that I ...
4
votes
2answers
3k views

Can I restore a SQL Server 2008 R2 backup to SQL Server 2008 R2 Express?

I have a server that's currently running SQL Server 2005 Express, and I need to restore a database backup that a developer has modified using SQL Server 2008 R2 [I think the full version, but still ...
1
vote
4answers
216 views

Sql Server Backup Compatibility - 2008 with 2005

I'm hoping to restore a backup from SQL Server 2008 into a Sql Server 2005 instance. Is there a way to have Sql 2008 back up in a format that 2005 will understand?
1
vote
1answer
151 views

replace set of integers with respective string values

I have a query which return the output like -- 5,4,6 Where 1 = apple, 2 = mango, 3 = banana, 4 = plum, 5 = cherry, 6 = kiwi etc. I would like to update my output as cherry,plum,kiwi instead of 5,4,6 ...
1
vote
2answers
881 views

Migrating to a new SQL Server machine: should master database be restored?

I'm currently working on a migration plan to migrate our SQL Server to some new hardware. The current installation is SQL Server 2005 standard: it used to be clustered but the node got removed at ...
0
votes
2answers
622 views

How to move the files of a replicated database (SQL Server 2008 R2) to a different drive

I would appreciate if someone could help me with the following problem: We use two SQL Server 2008 R2 databases under transactional replication: transactional publication with updatable ...
1
vote
1answer
390 views

Can I install a 32-bit SQL Server 2005 alongside a 64-bit SQL Server 2008 installation?

The place where I work at currently runs a 32-bit SQL Server 2005 installation on its server which we work with. In addition, the systems we are developing on have not yet been tested for 64 bit ODBC ...
0
votes
2answers
98 views

Restore database to SQL server 2008 from SQL server 2005

I need to restore my database to SQL server 2008. Currently we are having our database in SQL Server 2005 in one server. We need to take the back up of that database and move that database to SQL ...
0
votes
2answers
149 views

Install SQL Server 2005 on computer with an existing SQL Server 2008 installation

I have a Windows XP 64 bit workstation. I installed SQL Server 2008 R2 Standard x64. After that, I installed SQL Server 2005 Standard x64. Installation completed with no issues, but no instance was ...
1
vote
1answer
292 views

Can BES 5.0 Express database be migrated from SQL Server 2005 Express to SQL Server 2008 R2 Express?

Would there be any issues for cross migration of database from SQL Server 2005 Express to SQL Server 2008 R2 for blackberry configuration database and database in general? If the database is backup ...
1
vote
1answer
2k views

Error opening SQL Script

I have a database running on SQL Server 2008 R2. It has been running fine for over a year and a half. Unfortunately, the application vendor have just informed us that they only support the application ...
1
vote
1answer
166 views

SQL Server SPID and connection pooling

What is the max value for a SQL Server SPID? How long can a spid be dormant before connection pooling occurs?
0
votes
1answer
192 views

How was the MSSQL Server database erased in the production server (that is a different version? )

I'm asking for help understanding what happened in my situation or what and if I did something wrong. I have production server running on a Windows 2003 server with MSSQL Express 2005 with an app ...
0
votes
1answer
101 views

Upgrading 32-bit SQL Server cluster to 64-bit

Here is my situation. $WORK has a trio of three clustered database servers (64-bit Server 2003) that are currently running two SQL Server instances. Unfortunately, when the cluster was set up a ...
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
39 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.
1
vote
2answers
100 views

Are SQL transactions finished before a planned failover?

If I'm failing over my server due to a OS patch, are in-process transactions allowed to finish before stopping the SQL service?
0
votes
3answers
41 views

Copying SQL Server 2005 Databases

We currently have a single SQL server (2005, on a Windows server 2003 machine) with 3 DBs on it that I would like to just straight copy so that I can run some test on them for an upgrade. I don't ...
1
vote
1answer
103 views

Move SQL server from 2005 to 2008 R2

I'm planning on moving a couple of our databases from 2005 standard to 2008 R2 Express. Can I just detach the DB's move them over to the new server and reattache them? Is there anything I should do ...
1
vote
1answer
562 views

Help with SQL Server 2008 permissions

Today I migrated a database from SQL Server 2005 to SQL Server 2008 R2 using the backup/restore method which went fine and did not generate any errors. I can log into SQL Server 2008 through the SQL ...
0
votes
1answer
124 views

Connect to SQL Server using Windows Group Authentication

I've got this SQL Server 2005 Express installation that's got a Database I'm trying to connect to through a software that gives me the error "cannot connect using the user 'mydoimain\myuser'. Meaning, ...
2
votes
3answers
210 views

How can I migrate the default four system DB into another partitions?

Why can't I see any detach / attach command in the 4 SQL Server system DB objects? I want to move it into separate partition for each database files and the log files for greater performance. Am I ...
1
vote
1answer
1k views

How to reduce the SQL Server transaction log on the fly for production DB?

I'd like to know which is the best solution possible to reduce the SQL Server transaction log in the live production server without downtime ? Database full backup - which should commit transaction ...
0
votes
2answers
513 views

what type of replication transaction should I use?

I can't understand the difference between transactional replication and merge replication. This is my scenario: In an organization I have a SQL server which need to collect information from different ...
0
votes
1answer
96 views

How to config a Linked server?

How do I config my linked server to connect to the other database with following properties: ServerName:saleh user:sa password:.... Computer IP address:192.168.100.146
1
vote
1answer
127 views

Sql Server Migration from 2005 to 2008?

We are planning to migrate sql server from 2005 to 2008.We have decided to create user logins manually instead of migrating from 2005 server, as we have different applications (windows services) ...
2
votes
2answers
100 views

Backwards-compatible (to SQL 2000) server version and compatibility version check

I have a script which uses features not present in SQL Server 2000. Specifically, the script creates a stored procedure which uses a data type added in SQL Server 2005. I need to use conditional ...
2
votes
3answers
139 views

Changing a SQL Server 2008 installation from instance to default

I've had SQL2005 on my pc, and recentely IT has also installed SQL 2008. Unfortunately, it was installed side-by-side with SQL2005, with the unfortunate side-effect that the SQL 2005 installation is ...
1
vote
3answers
263 views

SQL2005 Express Machine believes it's part of a Cluster fails to Upgrade

I have a machine where I am attempting to upgrade from Sql2005 Express to Sql2008r2 Express, but it is failing on the Rules check. Rule Check Result Rule "Not clustered or the cluster ...
0
votes
1answer
223 views

Can't uninstall Reporting Services on SQL 2005 (SBS 2008)

I am running SBS 2008 and have just installed SQL 2008 alongside SQL 2005. My understanding is that the default instance created in SQL 2005 is not needed and only the SBSMONITORING instance is ...
3
votes
2answers
7k views

SQL Server: dbo vs db_owner role member?

I'm assinging user to a new database. What is the difference of user being a default dbo user compared to assinging login as a db_owner role member?
2
votes
1answer
4k views

Do I really need to have SharePoint Server installed on my computer?

Ok, So I have another question about the servers. I’m reading this book here about created Visual Web Parts for SharePoint using Visual Studio 2010/ASP.NET, however when I select New Project-> Visual ...
3
votes
2answers
542 views

SQL Server Column Level Encryption - Rotating Keys

We are thinking about using SQL Server Column (cell) Level Encryption for sensitive data. There should be no problem when we initially encryption the column, but we have requirements that every year ...
2
votes
1answer
168 views

SQL 2008. What permissions needed to see log file free space?

I need to see how much space my log file has. What permissions need to be granted to do so? What script shall I run to see that? Thank you
0
votes
3answers
55 views

SQL Server 2005 features in comparing DB schema /tables

Is it possible to create or do it from SSMS to compare two different schema ? I need to compare database table in my current production DB to see which one is different in order to generate delta ...
3
votes
3answers
98 views

What is the standard method to keep track of the latest Cumulative updates for SQL Server?

What resources are good for keeping track of cumulative updates for SQL Server? I noticed that Windows update does provide a service for SQL Server.
2
votes
3answers
210 views

HA suggestions for geographically separated sites

I have 6 instances of sql server that I need to be highly available by being hosted on two sites (one as principal, one as DR). Transparent automatic failover is required. Most are fairly boring and ...
3
votes
1answer
97 views

Script to mirror MS SQL Server databases between 2 servers

I have about 200 sites each of which have 2 servers running MSSQL (2k5 at some sites, 2k8 at others) One server is production and the other is primarily there as a backup. We're rebuilding all of ...
0
votes
2answers
1k views

Index rebuilding on mirrored database sql server 2008

I have a mirrored database in full safety mode on sql server 2008 R2 Standard Edition. I want to create a maintenance plan to rebuild and reorganize the indexes on a weekly basis. Maintenance plans ...
0
votes
1answer
427 views

Advantages of multiple SQL Server files with a single RAID array

Originally posted on stack overflow, but re-worded. Imagine the scenario : For a database I have RAID arrays R: (MDF) T: (transaction log) and of course shared transparent usage of X: (tempDB). I've ...
1
vote
4answers
1k views

Why upgrade from SQL 2005 to SQL 2008 R2?

have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are ...
2
votes
4answers
200 views

Why upgrade from SQL 2005 to SQL 2008 R2? [duplicate]

Possible Duplicate: Why upgrade from SQL 2005 to SQL 2008 R2? I have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI ...
0
votes
3answers
101 views

Migrate data from SQL 2005 (hosted) to SQL 2008 (in-house server)

We have a databased hosted with a "commodity" SQL hosting company. It's currently hosted on a SQL 2005 server. We have just configured a dedicated server (to which we have "root" access) running ...
3
votes
8answers
6k views

How to stop Log file from growing in SQL Server 2008?

In my application right after restore I perform many(>100,000,000) updates to the newly created database. Thus, LOG files grows significantly. How can I stop it from growing? NOTE: Setting recovery ...