Hi,

Seems like the problem is with the RS deployment itself. If you reinstalled the SRS recently and having this problem, please go through the following support links which can help...

Hi,

The query being used will not hold the data for the backup thats currently in progress. It would only mark an extry once the backup is completed.

However if you...

Hi,

Check is the backup file is not corrupted? Use RESTORE VERIFYONLY for the backup file and chk if it runs withour any issue.

JFYI: 'RESTORE VERIFYONLY' verifies the backup but does...

Hi,

Also there could be a posibility that few records must be deleted at the source table at some point of time. Later when this table gets exported to any destination...

Hi,

All the error message indicate one thing and that is you have got problems with your disk. The backup is failing as it is not able to read the file...

Hi,

The query being used holds good, .bak extention is an option and is not Mandatory.

backup database Update_Master_Khasm to disk='\\10.1.5.250\Khasm\igmastback'

go

However please check the following:

>> If the account running the query has...

As already discussed, incase if you are a sysadmin on the box, you will be in a position to grant database access to the required user...

However going forward its...

Small correction in the query:

if (SELECT DATEDIFF(day, crdate, getdate()) FROM master..sysdatabases where name = 'dbname') > 10

BEGIN

drop database 'dbname'

END

Else

PRINT 'Database not older than 10 days'

Hi,

Based upon your requirement, incase if you do not want to have a particular database older than 10 days...You can create a job with the following condition and schedule it...

Proper shutdown of a SQL Server is very much similar to a proper PC shutdown.

Where in the later case we close all application in use and make sure that...

This typically seems like the database was not put in 'standby mode' which should have been ideally done. As such you are not able to query the database.

Can you...

Can you check if you able to ping the server?

Also try using the FQDN or IP address in the connection string than just the machine name.

Can you verify if all the steps were correctly followed while copying the database. Like the wizard shows the objects that needs to be copied like:Logins\Stored procedure\jobs\packages etc.

You have to...

Hi,

Do you mean "Replace old data" - Replacing the data at the new server (new subscriber), then it would definelty replace the old data, because any type of replication is...

Hi,

Seems like the msdb database was also migrated and hence all the system tables were overwritten. In this case the sysjobs table was overwritten by the source server and hence...