restore the excryption key and check the reports.

Can i override...

Use alter DB and move the files, restart the services to take the settings effective as SQl resets tempdb during startup.

what is the exact error on logs?

Both possible.

for downloading rdl files use rsscripter(free).

Full backup with log backup will result in minimal data loss

but

what happens if a server goes down in half way in your cold backup.

if you say redundant initiate mirroring...

[quote-0Is there a way to create a identical server ?[/quote-0]

if you say indentical then possible.

You havent mentioned about DR?

Some good things

Recovery in terms of complete windows server will be so easy in virtualization.

skb 44459 (8/21/2013)

---

Is there a way to create a identical backup sql server for existing sql server 2005.

We would like to keep the same name also.

The new server will have...

in that case how will you store non numeric values in a decimal field?

try using replace and update it on same field, if you want to use the same column...

Go for local backup and ask the backup team to backup from that location.

hope local drives are SAN drives mounted?

Gail,

Just a thought, both services are managed by DBA and all SQL service account will be with DBA what wrong in giving the same account.

If it is not working take the same parameter and map it to a variable inside the dataset and minus it by 3 , really amusing it works perfect...

but what is the reason behind that

Are you using different account for SQL server and agent? why?

This is what i have tried it is working, can you delete the dataset and create again.