Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2005]

Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This tag is for questions on the 2005 version

1072 questions
0
votes
3 answers

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 (upgrade script) Thanks.
Senior Systems Engineer
  • 1,275
  • 2
  • 33
  • 62
0
votes
1 answer

Most suitable 'replication' technique for SQL Server 2005

I have a SQL 2005 database that is currently 15GB in size. We do a lot of web / intranet based reporting from thsi system and we're seeing a performance hit as a result. I'd like to create a copy of the live database on another server and have it…
Marko Carter
  • 4,092
  • 1
  • 30
  • 38
0
votes
1 answer

sql store procedures

i want to copy store procedures from one database to other database with different servers.. may i know how
mak
  • 1
0
votes
1 answer

How to set the verbosity logging for SQL Server 2005 on Windows Server 2008 x64

I'm literally in tears right now because I can't find any way to turn up the verbosity of SQL Server 2005 logging. Does anyone know how to do this, because I'm about to shoot a hostage every hour on the hour. Thanks, Dennis
FLX
  • 141
  • 8
0
votes
2 answers

Can not connect to SQL server with SQL Authentication. But can using Windows Authentication

The server authentication is set to: SQL Server and Windows Authentication mode I can connect using Window authentication but not SQL authentication. Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456) Error Number: 18456 Severity:…
NitroxDM
  • 635
  • 1
  • 15
  • 29
0
votes
1 answer

Unusual CPU usage on SQL 2005 Mirror

We are running a mirror on SQL Server 2005 SP2 Enterprise edition for a few databases. These are running on VMWare with Server 2008 R2. On the mirror server, I see the CPU go up to 50% for about a minute every 10 minutes (on the tens). Here's…
Paul Kroon
  • 2,250
  • 1
  • 16
  • 20
0
votes
1 answer

SqlServer2005 Enterprise Fast Recovery, SqlAgent Availability, and Replication

I have a database under SqlServer2005 Enterprise 64bit sp3, that is in phase 3 of 3 of recovery after a reboot without normal shutdown. It looks like with fast Recovery, the database became available when recovery moved into phase 3. However, it…
automatic
  • 205
  • 1
  • 2
  • 5
0
votes
2 answers

SQL Server 2005 log file not truncating

Got something strange (to me ) going on with my SQL Server 2005 database. The log file has very gradually grown huge. Running dbcc loginfo('dbname') shows everything in the log is active (Status 2) Running dbcc opentran shows 'no active open…
Robin
  • 817
  • 3
  • 11
  • 20
0
votes
2 answers

move backend database for enterprise project management, Project Server 2007 installed on WSS 3.0

I am a database administrator and I need to move SQL databases from one server to another for enterprise project management, Project Server 2007 installed on WSS 3.0 (both at patch level SP2 + Aug09 CU). I know how to move databases but I don't know…
Manjot
  • 333
  • 1
  • 3
  • 17
0
votes
2 answers

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 are set to take full backups 3 times a day and…
kishore
  • 872
  • 3
  • 13
  • 28
0
votes
1 answer

How to do full computer backup and restore on Windows 2003 running SQL Server 2005?

This is a question for someone who has had hands-on experience with this. Mainly I'm wondering whether this is a straight-forward process that can be achieved with the backup utility included with Windows 2003. Of course, we would prefer to maximise…
Darren Campbell
  • 1
0
votes
2 answers

Reducing the initial size of database log file

Microsoft SQL Server 2005 I want to reduce the initial size of a database (to a size below what it is currently) and then back up the log file. Is this a safe way of reducing the size of the log? Doing a log backup without reducing the initial…
Aushin
  • 1
  • 3
0
votes
1 answer

Patching New Node on SQL Server 2005 /Windows 2003

adding a third node to an active/active cluster (currently sp3, no updates). adding the node for each virtual server through add/remove programs seems straightforward, but need to also install sp3 on the new node. Should I run sp3 from the active…
p feakins
0
votes
1 answer

How can I recognize which Ms sql server db use more system resources?

I have a SQL server 2005 Express ed on my server and have 20 db on it. I see the Sql server worker process uses many cpu and ram ( 35 - 50 % cpu and 2 GB of Ram) I think there must be some fault on one ore more dbs. but how can I recognize which db…
Ashian
  • 400
  • 1
  • 7
  • 24
0
votes
3 answers

Restoring a backup SQL Server 2005 where is the data stored?

I have two Sql Server database instances on two different machines across the network. Lets call these servers A and B. Due to some infrastructural issues, I had to make a complete backup of the database on server A and robocopy the A.bak over to a…
sc_ray
  • 107
  • 1
  • 6
1 2 3
…
71 72