Sorry tjm,

That was happened approx. 2 years back. I think we have resolved it but I couldn't remember how we have fixed it. No more I am working on that...

Well, I believe differential database is also not allowed for 'Master' database.

Refer SQL Server Books online to know how to configure an automatic backup using SQL Server Agent. You can create an SQL backup job.

Hi,

REPLACE clause should be used if you want to overwrite the existing database or its related files thro' restore. With REPLACE clause, SQL Server does not conduct the saftey check...

hi..,

U can get the .mdf and .ldf file names associated with the particular database by executing the following query on each database,

select * from [DatabaseName].dbo.sysfiles

or

select filename from [DatabaseName].dbo.sysfiles

regards

deena

hi,

Depending on the recovery model set to each database,

sql server allow full backups as well as log backups,

but for master and tempdb only full backup can be taken on master...

ya, it works fine,

I have restored the database prior to a transaction log which makes the problem, then how it would be the point-in-time recovery.

regards deena

ok, fine

Now I have been trying to restore a transaction log using only stopat not stopatmark, after restore

the respective database in EM shows a (loading)

I could not access that database,...

hi..

you can restore the db after executing the below T-SQL

using SQL QueryAnalyser.

ALTER DATABASE yourdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE

close query analyser after executing the query.

now try to restore yourdb...

Query used for full backup restore is

osql -S (local) -U user_name -P password -o output_file_name -b -Q "RESTORE DATABASE database_name FROM VIRTUAL_DEVICE=device_name WITH BLOCKSIZE=65556, MAXTRANSFERSIZE=4194304, NORECOVERY, REPLACE, STATS=10"

Query used...

My restore command were

osql -S (local) -U user_name -P password -o output_file_name -b -Q "RESTORE DATABASE database_name FROM VIRTUAL_DEVICE=device_name WITH BLOCKSIZE=65556, MAXTRANSFERSIZE=4194304, NORECOVERY, REPLACE, STATS=10"

I have a full and...

>> 1. From where you have taken the backup? same server?

same server having only one instance

>> 2. Was the backup taken by SQL Query Analyzer / Enterprise...

hi,

Where could i get a detailed explanation of stopat option with mark_name, if the posted replies or not sufficient, I could not find such an example in BOL

thanx in advance

deena

Fine, Got it

Thanx deena

hi

I am using ODBC to connect the db with VC++

I have not tried SQL DMO. Do I able to list the servers without connecting to the server in local...