I am not sure, but is this correct: I ran a full backup at 2pm, t-log are backed up hourly. I have a "problem" at 6pm. In order to properly...

When you are creating maintenance plan it will ask you for database backup..."Specify the Database Bakcup Plan" tab is for full backup "Specify the Transaction Log Bakcup Plan" tab is...

If you are stopping the running job it reports as cancelled ("The step was cancelled (stopped) as the result of a stop job request. ") not success.

It is reporting as it...

Detach the existing database using EM or sp_detachdb procedure and rename .mdf and .ldf files with suffix _old...

Copy the new .mdf file which you get from your backup server to...

I don't know what is the reason you want to delete 7 days data from the app.. which can be done using sql job...

If I want to do it.. Here...

Don't forget to take full backup without any delay after major modifications to the db.

Maintenace plans are easy to created but in 2005 there are some issue to be addressed..

You can write a script for backup, reindexing and dbcc checkdb ect.... You can create...

May be your disk was formatted with compression enabled.

Check with your system admin..

Are you able to create a database using create db script?

I don't thin there any way to compare without decrypting...

But you can check some third party tools which compares object schema/data out in the market.

ex: http://www.x-sql.com/

Either you need to remove the constraint on the destination table or change your source query to

'select *, 'value for not null column' from tablename

If it is memory issue then it might be MemToLeave memory which 256 MB by default...

All extended procedure, com objects and linked server calls uses MemToLeave memory...

Only the option is...

Try this..

dbcc checkprimaryfile (N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\admin.mdf', 0)

go

dbcc checkprimaryfile (N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\admin.mdf', 1)

go

dbcc checkprimaryfile (N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\admin.mdf', 2)

go

dbcc checkprimaryfile (N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\admin.mdf', 3)

go

Way back I used the command to read the .mdf file details... I don't remember at this time but if I get it I will post it..

Meantime you can attach...

If your service account has the access I belive you can use UNC name like '\\servername\c$\test.bak'

OR

Run the backup locally and copy the backup file or FTP it.

Read this article...

http://www.devx.com/gethelpon/10MinuteSolution/16507