1
vote
3answers
57 views

SQL Server 2005 Issue

I am stuck. I've just taken over maintenance on a SQL Server...that has not been backed up in quite a while...The log file has grown to over 1.61TB...Yes, 1.61TB. It has swallowed all available disk ...
0
votes
1answer
187 views

SQL Error When Running My “Find All Unused Packages” in SCCM 2007 Report Console

SQL Error When Running My "Find All Unused Packages" in SCCM 2007 Report Console Asked by: the_ratzenator I am trying to run an SCCM 2007 Report to find all unused Pacakges in my environment and I ...
0
votes
2answers
116 views

SQL services wont start due to incorrect drive letter after windows restore

SQL services wont start due to incorrect drive letter after windows restore Had a server crash, was successfully able to reinstall windows and restore the server SQL and all the necessary services ...
0
votes
2answers
225 views

Best way to upgrade Hard Disks holding SQL Data Files?

We have an SQL 2005 Server we need to upgrade the Hard Disks on. The most efficient way I can think of to do this is the following; Run a backup using Backup Exec on the D:\ Partition (This ...
0
votes
1answer
59 views

Delete data from a SQL Server database on a full partition

I have a SQL Server 2005 Database on a dedicated partition, during the time the database grown and now it have occupied all the space on the partition, now the problem is that the only operation I ...
1
vote
1answer
284 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 ...
1
vote
1answer
239 views

Restoring Microsoft SQL databases to a different disk partition on the same server

We have a SQL Server 2005 box running Windows Server 2003 R2 Std 64bit. We have two production databases residing on one partition (which is an iSCSI software target), that partition got apparently ...
0
votes
0answers
4k views

Cannot telnet to SQL Server on port 1433

I've been working solidly on this issue for the past three weeks. I cannot seem to find where the actual issue is. I just recently found this article on how to troubleshoot the connection. I made it ...
0
votes
1answer
70 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 ...
1
vote
1answer
103 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 ...
0
votes
1answer
52 views

SQL Server Expensive Select Queries from unknown source

When viewing Queries by CPU usage with Performance Dasboard, I notice a great deal of queries like "Select * from dbo.sometable". What is the best way to go about tracking the source of these queries? ...
1
vote
2answers
280 views

dotnet framework 2.0 sp2 breaks CLR integration in SQL server

It appears that CLR integration does not like Dotnet framework 2.0 sp2. I am getting the following error message when trying to run code that depends on the clr. Msg 6510, Level 16, State 11, Line 1 ...
1
vote
2answers
382 views

Distributing SQL Server on Internet regarding security issue

We are going to put our servers in two places to keep high level redundancy and to avoid bandwidth critics. The two servers are on different LANs but communicate over a WAN network (via Internet). One ...
0
votes
1answer
414 views

Connect to SQL Server 2005 In Different Network

I need a help on SQL Server Remote Connection Issue. I have Windows Vista with SQL Server 2005 installed.I need client to connect to my system. My client is in VB6 uses SQL Native Client.Clients which ...
0
votes
1answer
136 views

Orphaned SQL Recordsets/Connections with IIS

I have an IIS 6 site running on Windows 2003 Server x86 with MS SQL2005 Enterprise edition running ASP Classic (no choice). The site runs very fast with about 8000 page views per hour. All of my SQL ...
2
votes
3answers
81 views

MS SQL 2005 - Backup “being used by another process”

I'm trying to create a backup file of a database in SQL 2005. When I try to execute the backup operation I get an error saying "cannot access this file, it is in use by another process". Any advice ...
3
votes
2answers
136 views

Windows Cluster - Can I failover without disturbing SQL?

I have a 3 node cluster. All of the nodes are part of Cluster01 in what should be A/A/P mode. Usually instanceA and instanceB of SQL Server would reside on NodeA and NodeB respectively. the windows ...
0
votes
2answers
135 views

AWE turned on but still not using memory

I do have a server 2008 64 running a SQL server 2005. I do have 8GB on the server and I want SQL to use most of the memory on that server. I have turned the page-locking on for the account and also ...
3
votes
1answer
124 views

sql server 2005 encoding problem

Ive got text file with utf-8 encoding with more then 2k lines of insert command. Now I would like to execute it as a sql script to insert data into database. There is greek text with which there are ...
3
votes
4answers
684 views

Lower the I/O priority for backups

I have a job that nightly runs a backup of all attached databases however it can bog the server down if someone is connected during that time. I have TONS of CPU overhead to work with (I am barely ...
0
votes
1answer
188 views

Cannot open backup devices

I'm getting this error Msg 3201, Level 16, State 1, Server server\instance, Line 1 Cannot open backup device '\\server\share\database.bak'. Device error or device off-line. See the SQL Server error ...
1
vote
3answers
95 views

how to set up SQL server

I am very new to SQL server ( 2005 to be exact ) but have been given a backup of a database (in .bak format) which i need to query. My issue lies with this as I have no idea how to set it up so I can ...
1
vote
1answer
521 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
32 views

SQL SERVER Query result performance question

When I run a simple query on server SSMS it takes 3 seconds. When I run the same query on my computer on SSMS it takes 35 seconds. What could be the reason? What should I check first? I tried disable ...
6
votes
2answers
4k views

How to attach mdf files from a different SQL Server Install?

Hi I have mdf and ldf files from a different SQL Server install from a machine i dont have access to now, and would like attach them to my current install to get at the data. When I try this, I get an ...
1
vote
2answers
59 views

Sql Server improving performance with monitoring etc

What are some ways I can constantly monitor and report on my production sql server so that I can determine where locks and performance improvements can be made?
0
votes
1answer
186 views

Is it possible to move sql server databases (physical files) without detach/attach

I want to move physical location of all my databases (around 20) to new location. sys.master_files (physical name) column gives me path of databases. If I copy physical files to new location and ...
1
vote
1answer
191 views

Can you use a relatively expensive filter on transactional replication?

I'm trying to replicate (transactional, push) a relatively small table (50K rows), subject to several different filters, which are rather expensive (each taking at least an hour long to complete, ...
0
votes
2answers
509 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
95 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
556 views

If install SQL Service pack 4 on SQL2005 instance do I need to install also earlier SPs

I am little lost in touch whit few SQL servers regarding to their updates. Now I want to update these serves and I see that now is actual SP4 for SQL2005 databases. My question is: If I skip SQL ...
0
votes
1answer
74 views

SQL Server 2005 inserting null when value hard coded

I have a stored proc that creates an entery in a table. INSERT INTO tbl_CaseDetails ( Case_Id , Client_Id , Client_HO_Id , Client_Case_Ref ...
2
votes
1answer
53 views

Migrating data from SQL Server 2000 to SQL Server 2005

I have to migrate existing data which is in SQL Server 2000 to SQL Server 2005. The schema of two databases is different. For Example Locations table in SS2000 is split into two tables and has ...
0
votes
3answers
53 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 ...
0
votes
0answers
397 views

sql mirroring error SQL Server 2005

I have 2 db's that have been happily mirroring each other for months. Today both DB entered the state (principle, disconnected). I am unable to stop the principle(db1) from mirroring. Error Msg ...
2
votes
1answer
76 views

VM migration of SQL Server

We have two SQL Server VMs (SQL 2005 x64 on Windows 2003x64) both have RDM SAN. The SQL Servers are also clustered. My VM admin will be migrating us to different VMs using Cisco UCS solution. ...
0
votes
1answer
44 views

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 ...
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
198 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 ...
1
vote
1answer
52 views

Proper Settings for SQL Server 2005 Profiler User Auditing

I have been tasked with creating a catalog of all users\applications that access a particular database at our company. The issue is that we have no idea what users are using the database and what ...
0
votes
1answer
219 views

SQL Server 2005: Corrupt database - Automatically shutdown DB?

Lately I experienced a corrupt DB because of a defective harddisk. SQL Server 2005 detected the issue and put entries into Windows event log about inconsistent DB and invalid page checksums. But it ...
0
votes
1answer
587 views

SSL Encryption with SQL Server 2005 Express not working as desired. No TLS/SSL protocol packets found

I'm trying to get SSL encryption working on SQL Server 2005 Express edition Svc Pk 3. I've tried everything (worked the whole weekend), but I dont see TLS or SSL packets when I look at traffic using ...
0
votes
2answers
82 views

SQL Server problems

I have installed SQL Server 2005 but there is no server, I have reinstalled it about 5 times and the same problem never changes. And here is the error message Cannot connect to .. ADDITIONAL ...
0
votes
1answer
38 views

Can not access SQL 2005?

the SQL has been installed but there is no server name and the Program does not accept any server name , and all the options , like the TCP , ports and Remote access are enabled
2
votes
3answers
271 views

SQL Server 2005 backups for previous 5 days on disk?

My goal is simple. I want to have SQL Server keep a nightly backup of a DB for a rolling 5 days. So each night at some time I want a new DB backup made and one deleted such that I have a rolling 5 ...
2
votes
3answers
845 views

SQL Server Transaction logs full, how to empty and delete them

My transaction log file is full, i have 5 log files , 2 in D: drive & 3 in E: drive. all the log file is full, each log file is 10GB in size. I need to delete all 5 transaction log file and need ...
0
votes
1answer
796 views

How to change schedule of backup jobs using SQL Management Studio

I have an SQL Server 2005 on our lab network, I installed MS SQL Management studio on separate computer to connect to the SQL Server to schedule a backup job of a few database. It worked fine for the ...
0
votes
2answers
73 views

SQL Server database recovery issue

In SQL Server 2005 when I try to attach my database (MDF) it shows 'not a primary database', but this database has one MDF and one LDF only. How can I fix it?
2
votes
3answers
4k views

64K Cluster size for SQL Server Log Files

I was wondering if we put the SQL Server Database Log file and tempdb on RAID 1, should be format it with 64K cluster for better performance? Currently the database and log file are on RAID5 which I ...
3
votes
3answers
1k views

SQL Server Backup retention policy

I need to backup database in full recovery mode with a condition as: 1. Backup database, only when space is available for backup operation and Backup retention policy must be like expect last two days ...