To check the port go to SQL Configuration Manager and click on SQL 2005 network configuration.

Select the instance --> right click tcp/ip --> properties --> ipaddresses tab then scroll...

The values should match.

Checking identity information: current identity value '1035637357', current column value '1035637357'. Is okay becauses it matches.

Null does not match 64. So I would reseed this...

You can even highlight a database in SSMS and click the delete key.

If you want to delete a database you can:

USE [master]

GO

DROP DATABASE DATABASE_NAME

GO

if you want to delete backup history you can

USE [master]

GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'DATABASE_NAME'

GO

Right click on the table --> script as --> create to ...

Right click on the database --> tasks --> export data --> follow the wizard

You can also directly insert data...

If you take your backup command out of the stored procedure, and supply a db name, does the differential backup work?

It may have something to do with the variable types...

Which release of service pack 2 do you have? If you have the initial release, there is a bug http://support.microsoft.com/kb/933508.

The bug basically adds the next date increment to the...

This is a comprehensive walkthrough step by step.

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004,00.html#setup

In summary the steps consist of:

1: backup the db

2. Restore the db on mirror

3. configure mirror through wizard on principal.

If you run the statement I just posted the seed will be the maximum value which is 1001505 in your case.

If you want to start the seed at 1 or...

Looks like you need to reseed.

DBCC CHECKIDENT ( 'table_name', RESEED )

more info here:

http://msdn2.microsoft.com/en-us/library/ms176057.aspx

If there is not much space to gained from shrinking the database, your best options are to create secondary data files on seperate drive/mount point, or detach/attach the mdf to...

Right click on the database --> tasks --> Shrink --> database and see what percentage of allocated space is not being used.

By shrinking the database you can return space...

It happens when you SSCrazy 😀

GilaMonster has a valid point about indexing. What are your indexs on the table and how many records does this table have? At 50 transactions/sec I would imagine...

GilaMonster is this in the wrong thread?