GilaMonster (12/22/2008)

---

There are no errors there. That's SQL's startup messages. You need to connect to SQL from another command window, using sQLCMD and restore the database.

Does the restore database...

Find attached the text file....

Sql server successfully starts in single user mode....however the restore command as I posted doesn't runs....please find attached the snapshot

I am using these batch commands to restore master database......

Net Stop MSSQLSERVER

cdset path=C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn

sqlservr -m

sqlcmd -Usa -Psql2005 -Q "restore database master from disk='D:\SystemDatabaseBackups\MasterDatabaseBackup' with replace

Net Stop MSSQLSERVER

Net...

GilaMonster (12/20/2008)

---

Of course. An instance can't be running twice, it would conflict on...

Jonathan Kehayias (12/19/2008)

---

Have you looked at the Reporting Services Scripter by Jasper Smith:

http://www.sqldbatips.com/showarticle.asp?ID=62

Not trying to be funny, but you are kind of reinventing the wheel, you just probably don't realize...

Is there any specific order for restoring system database.....

I need to prepare a Backup strategy for our application to work with in an hour, If in case client system goes dead....Normally I take backup of user databases...

thanks Gila... SOS_SCHEDULER_YIELD is taking too much CPU...how to solve this issue

I am down with fever .... will definitely let you know when I will work....

Thanks .... Jeff ...I was running short of time....so I decided to do this in SSIS......

I will certainly review your code....actualy...I think its better to write these things rather than...

the code is same as posted earlier......I don't know how to traverse the directories....do u have a logic...

Jeff Moden (11/17/2008)

---

One problem at a time... have you gotten to the point where you can...

I don't think so......

As if I pass the full path in the variable it still gives the same error....

thanks bhawna......

Actualy I was looking for a solution in SSIS......

I created a ForEach loop container and a variable "GetFile" under a variable mappings in foreach loop container.

I then created an...