Two way

SSMS

1) In Restore dialog use

To a point in time option to choose the time.

2) with Restore database t-sql use stopat parameter.

Thank you all for the response.

I am going with differential backup for now. I have big implementation this weekend to migrate databases from one data center to another.

We are also...

My SQL 2005 on SP1 but it fails on SQL 2005 as well. Except it works from Siebel. I am looking into Siebel. Thank you all.

Something to this extent. I don't have the schema as I am investigating this issue from Siebel side where same query works connecting to SQL 2005 and failed SQL 2000....

Thank you.

Marvin, just to give that a thoughts once I do the full database backup and differential backup, differential backups are incrementing day by day so the last differential backup I...

You can use the xp_sqlmaint for your backup with parameter

-DelBkUps 5DAYS

That will take care of your old backup files older than 5days.

One of the reason that you see the file size is big when you use BACKUP DATABASE command could be because your backup file under E:\ drive is append with...

Do you want the new server to be same name as the other one? Do you need all the login informaiton? you have to look at it what do oyu...

Thank you.

try using at command and osql at os level if you are on express. just thoughts

Check which account do you use to run SQL server on both server and make sure has necessary permission. like connect.. etc.

Found it but doesn't work all time. as long as its in cache.

DECLARE @Handle binary(20)

SELECT @Handle = sql_handle

FROM master.dbo.sysprocesses

WHERE spid = spid#

SELECT *

FROM ::fn_get_sql(@Handle)

one more thing if you are using tempdb during this process, make sure your application data, log and tempdb are on seperate drives too. good luck.

Jone, even though your database is in simple recovery mode, it uses transaction log while its building the your database.

Is the building jobs has more data than before? One...