Microsoft SQL Server Administration

SQL Server 2005 Restore DB Name **INCOMPLETE**

Joe K. - 19 Jun 2009 6:31 PM - 3 messages

I have a production database backup file that I have created from SQL Server 2005 maintenance plan. I have backup the database with SSMS task and backup program. Also created t-sql script to backup the database. But listed below ...

change date from Mon dd yyyy

DONNA - 19 Jun 2009 3:28 PM - 13 messages

How do I change a varchar field that is in the format Mon dd yyyy 12:00am to MM/DD/YYYY? Thanks for any help... ...

Backup and restore sql server 2005

Fabrice - 19 Jun 2009 3:19 PM - 5 messages

Hello, A question about backup and restore. I'm not an export of sql server. I have installed sql server 2005 on windows 2003 R2. On my server i have two partitions. C: and D: Mon named instance is installed on D: ...

c2 files/sysxmitqueue

guest5 - 19 Jun 2009 3:19 PM - 4 messages

Hi I have an issue at the moment where large no of c2 audit trace files are being generated for audit event 114. At the same time msdb is being rapidly filled by sysxmitqueue. I am unsure whats changed as this server has not had this issue presviously. ...

Query is much slower in 2008 than in 2005

wpher56 - 19 Jun 2009 1:22 PM - 7 messages

Hello all we have a query involving several tables, subselect and scalar-valued functions. It ran in about 10 minutes in SQL Server 2005 on a old server with 4 GB of RAM. Now we upgraded to SQL Server 2008, on a server with 8 ...

IIS Vs Apache

NeWGeeK - 19 Jun 2009 12:03 PM - 2 messages

IIS Vs Apache I am planning to host two web sites on my pc at home. My OS is WinXP SP3 and I am at crossroads if I should use IIS or Apache as a webserver deamon. I am behind a router and a modem and therefore forwarding port 80/81 and ...

Seem to recall a video presentation on importing 2005 workload

Joe - 18 Jun 2009 9:48 PM - 2 messages

and other environment variables to a different server to do performance tuning there. Any recall this/ where it might be located? Or perhaps some other information about replaying a trace on a 2nd server? ...

SQL Server 2005 database monitoring

jfalberg - 18 Jun 2009 8:51 PM - 5 messages

We have the need to monitor and determine the amount of data being writing to a SQL Server 2005 database on a daily basis. Maybe hourly â€¦ Can somebody help me determine the best method to track this? ...

Alter Table Conflict with Index

Rob - 18 Jun 2009 8:15 PM - 2 messages

I am trying to run a script which has several Alter Table commands being run, to change fields from Numeric (6,0) to Numeric (4,0). Problem is on tables that have indexes that use this field, it errors. Is this because it is ...

How do I get the SSIS package back to SQL Server?

BillE - 18 Jun 2009 6:31 PM - 2 messages

I created a SQL Server 2008 SSIS package and scheduled it in a Job. Now I need to modify the package, so I opened Business Intelligence Development Studio, created an Integration Services project, and imported the SSIS package and made some changes (not a very user-friendly process). ...

SQL 2008 not starting

Robin9876 - 18 Jun 2009 4:13 PM - 3 messages

On a SQL 2008 (SP1) an instance is not starting up. Below is the relevant lines form the errorlog when the first error is mentioned. I have tried copying the model database files from another SQL server at the same build level but the error still occurs. ...

HELP, RAN OUT OF DISK SPACE

Rockitman - 18 Jun 2009 3:57 PM - 10 messages

SQL2000, one of my databases is not currently under a maintenance plan and this morning, I've come to find out my D: drive is out of disk space!!! Looking at D:\Miscrosoft SQL Server\MSSQL\Data directory I see the file ...

Restore without some logins

David C - 18 Jun 2009 2:28 PM - 2 messages

We do development work for several customers and when we restore a copy of their database on our servers it restores the customers login/security settings. Is there a way to restore without restoring the security on the database? Thanks. ...

SQL 2008 Restoring Database

Robin9876 - 18 Jun 2009 2:06 PM - 4 messages

On a SQL 2008 server a database has been listed as restoring for over 24 hours. The database is 40 Gb in a single file and the server resources are only slightly being used. How can I check how far along it is on the restore process? ...

Active/Active cluster with bcv disks

Abba - 18 Jun 2009 8:15 AM - 4 messages

Hello, [SQL2008 EE 64 bit on Win2008 64 bit] Is is possible to configure Windows2008 Active/active cluster on BCV disks? Has anyone implemented that? Background: Node1 has OLTP database and Node2 has Reporting database. The plan is that using EMC replication manager, it is easier to sync the ...

Sql Server Shared Hosting

Sabotage - 17 Jun 2009 7:58 PM - 5 messages

Hello, I'm looking for a cheap Sql Server 2005/2008 shared hosting provider. My software requires hosted MSSQL database to access remote MySql database hosted on the other server. On my local machine I've done this by creating a ...

2008 Express setup mapping error

David C - 17 Jun 2009 7:39 PM - 2 messages

I setup SQL Express 2008 (with Adv services) on a laptop and the install completed, but it gave me the error below. The database seems to work fine but I was not sure if this error was a problem. Can anyone help? Thanks in ...

How to narrow down the failure message

JamesWilliams - 17 Jun 2009 6:05 PM - 8 messages

I have a nightly job which copies the entire contents from a Progress (kinda like Oracle) database to a SQL Server 2005 one. Specifically, I look under SQL Server agent in the tree on the left of SSMS, and open it up and expand ...

can't delete maintenance plan

Rockitman - 17 Jun 2009 5:12 PM - 5 messages

I'm trying to delete a maintenance plan that I created in SQL 2005. First I right click the plan and select Disable. Then I right click the plan and select Delete. A Delete Object window appears and I click OK and the error message states: ...

SS2005 Licensing in VM environments

INTP56 - 17 Jun 2009 4:12 PM - 2 messages

I've read documents and threads on this issue, but I still can't come to a place that everyone can agree with. The actual box in question has 2 quad core processors. We are planning to purchase a product that has SS 2005 Standard as part of ...

logshipping on 2000

tulip - 17 Jun 2009 2:23 PM - 12 messages

we used logshipping between primary servers and secondary server, the distance is more than 1000 miles, the copy job need to copy a 60G files each week, is there anyway to fast the process? thanks ...

Run 32-bit and 64-bit instances on same machine

John - 17 Jun 2009 12:41 PM - 12 messages

Is it possible to run 32-bit and 64-bit instances of sql server 2008 on the same windows server 2008 instance? I searched and found this slide presentation that mentions that it is *not* possible under sql 2005: [link] ...

Database Snapshots

Abba - 17 Jun 2009 11:08 AM - 4 messages

Hello, [SQL 2008] [link] says... 1. "If the disk drive fills up, write operations to all the snapshots will fail....". Obviously the DB snapshots are read_only, so does this mean if ...

Tempdb log

Abba - 17 Jun 2009 3:56 AM - 4 messages

Hello all, [SQL2005] We get this error quite often - "The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.". I want to find the root cause for this error rather than a band-aid fix. What ...

Reseeding identity field

tshad - 17 Jun 2009 12:30 AM - 11 messages

I am trying to reseed the identity field in my program. My largest ID is 205001 and it is using 351223 I want it to go back to 205002 (use the Highest value in the Identity field which is what the docs say) but it still stays at 351223. ...

Permissions

Andy - 16 Jun 2009 7:38 PM - 3 messages

Hi, I have a table, myTable, in a schema named Schema1. I then created a view, dbo.MyTable and granted select permissions to certain database roles. The permissions on Schema1.myTable are left unchanged (no explicit grant or denies). Now, I've always been under the impression ...

remove extra log files

sacgar - 16 Jun 2009 7:33 PM - 2 messages

I have 3 log files and need to remove couple of log files from one of my DB in sql server 2005 and keep only one log file , so moving all the logs from these two log files to other 3rd log file which i want to keep ,what are the ...

SQL Help

bcap - 16 Jun 2009 7:27 PM - 2 messages

Hi, I have a table named Booking and another called Events A booking can have multiple events tied into it. Here is what my query results look like: EventID BookingID BookingName EventDesc ...

Change Column Position

Muhammad Bilal - 16 Jun 2009 7:00 PM - 10 messages

Hi. How to change the position of the column in a table in SQl Server 2000. Regards, Muhammad Bilal ...

SQL Server 2008 / 2005 / 2000 / 7 / 6.5 largest possible database?

Rajoo Sharma - 16 Jun 2009 6:37 PM - 11 messages

Does someone know what is the largest possible database with the following relational database systems: Sql server 6.5 Sql server 7 Sql server 2000 Sql server 2005 Sql server 2008 [link] ...

Compare Table Structure

Muhammad Bilal - 16 Jun 2009 5:44 PM - 4 messages

Hi. How to compare structures of two tables i.e. column name, datatype etc. and get the difference between the table structure. Regards, Muhammad Bilal ...

Move Log Shipping Primary Database to New Drives

Lijun Zhang - 16 Jun 2009 4:20 PM - 2 messages

We are planning to move a log shipping primary database to new drives on the same server. I have tested on a dev server by detaching the database, copying the database files to the new drives and attaching the database again. The log ...

Sql server 2000 SP4

db - 16 Jun 2009 3:31 PM - 2 messages

I have few applications running on sql server 2000 SP4. Other database applications are working fine but that application is slow. Its vendor suggested sql server 2000 is no longer supported by Microsoft. I recommend you upgrade to SQL 2008 or SQL 2005. ...

Schedule windows server and sql server reboot weekly

db - 16 Jun 2009 2:37 PM - 6 messages

Microsoft SQL server standard edition Microsoft windows NT 5.2 (3790) Platform: NT INTEL X86 Version: 8.00.2039 SQL server 2000 SP4 I have been told to automate rebooting of windows server and sql server and schedule it for every sunday morning. How do I schedule it? ...

Sum

Paulo - 16 Jun 2009 2:14 PM - 6 messages

Hi, if I have a simple select like "Select numericColumnType From sometbl" that shows a value on every line... But I'd like to know if on the last line of the RecordSet can be shown the sum of the values... ...

Log for when Objects are created changed or deleted

Chris - 16 Jun 2009 1:36 PM - 4 messages

Is there a way to set up a log for when objects are created, changed or deleted with in the SQL enviroment? For example, I want to know who created a stored procedure, changed a stored procedure or deleted a stored procedure. ...

Conversion from nvarchar to varchar

Kevin - 16 Jun 2009 1:07 PM - 6 messages

Hi, I recently helped a client convert their nvarchar columns to varchar for an entire database (thousands of columns). I thought this would reduce the size of the backup. But instead it enlarged it. Is there some kind of cleanup I ...

can't access sql datsbase

Neil - 16 Jun 2009 8:31 AM - 4 messages

I have problems with an installation of SQL express 2008. I have recently had to do a repair installation on SQL express and now can not access some of my SQL databases. I have a custom application that was written for me based on an SQL database. ...

error logging on SQL 2008

Zoran - 16 Jun 2009 3:11 AM - 8 messages

Hello All, I did have the same kind of a problem previously, and I now got it again - "cannot connect to localhost". I made a new installation of SQL 2008 on a Windows Server 2008, installed SP1 for SQL 2008, and after the restart of the machine, I cannot get in ...

MSDTC in Active/Active cluster

El - 16 Jun 2009 2:22 AM - 3 messages

Application is hosted in 4 way Active/Active cluster running SQL 2005 Ent. edition. We need to update data in all the databases in the four nodes. We are using MSDTC to update the data and we are able to update in the 3 nodes ...

Disk full from delete

tshad - 15 Jun 2009 11:00 PM - 15 messages

I am deleting over a 1.5 million records which is running my log out of space and it is set to Siimple Recovery. So now I need to break up my delete statement into 3 statements. Just trying to find the best way. I am deleting all the records and can't purge. ...

Determine actual row size?

James Hunter Ross - 15 Jun 2009 9:51 PM - 3 messages

Friends, I have written scripts to alter every VARCHAR field to become NVARCHAR as part of our Unicode support project. (It is very involved, removes dependecies, types, indexes, and puts it all back together again, works.) Back when I did this I assumed worst-case SQL Server 2000, and shortened ...

What happens to running trace when SQL is shutdown

David Hay - 15 Jun 2009 5:56 PM - 5 messages

I have created a trace that runs continuously keeping track of logins, and failed logins. It is being written to a file and imported into a table each hour. Now normally when the trace is stopped and closed, ...

How to BKP?

Paulo - 15 Jun 2009 1:18 PM - 9 messages

Hi, how do I use a command via Query Analizer to make a bkp on some database? How do I know it's fineshed? "DBName_DateTime.bak" <- must be the file generated I'm using SQL2000/5 Many Thanks ...

Change SQL 2008 product key

Mino - 15 Jun 2009 11:04 AM - 2 messages

Hi, I've installed sql 2008 trial version for purposes of testing. Now I have to move the server in production. Is there a way to change the product key of sql 2008 server??? Thanks to all for any suggestions . ...

Is it collation or something else

thejamie - 15 Jun 2009 4:10 AM - 7 messages

Until today I had not figured how easy it was to take a database created in 2000 and converted to 2005 or 2008 which had a LATIN_GENERAL... collation. All the collation issues were resolved by running an alter database to set ...

SQL2008 locking

Abba - 15 Jun 2009 2:37 AM - 3 messages

Hello, Has anything changed w.r.t Locking architecture in SQL2008 EE? If so, please share your experiences. Any article with more info and if possible a demo, would be helpful. TIA, AbbA ...

Fetch 1.2 million records in 30 seconds

Alan T - 15 Jun 2009 12:27 AM - 5 messages

I have a table with 1.2 million records and I fetched them all select * from myTable in 30 seconds. This table has 20 fields. Do you think that's too long? ...

Why sa shows in Logins

tshad - 14 Jun 2009 9:04 PM - 5 messages

I am working on my 70-431 test and am trying different things and noticed that when I add a new user to my laptop and then add it to Sql Server using: Create Login "MyLaptop\tomSql" from windowss It creates it fine. ...