Question related to recovery of SQL Server database..

In the event of SQL Server recovery... I have listed the following steps
(not detailed) as per reading SQL Server books online.
Step1. Install the SQL Server and related Service Packs
Step2. Restore the master database.
Step3. Restore the msdb (to restore the DTS packages and job schedules.)
Stpe4. Restore other system databases if it is required (optional).
Step5. Restore the user databases one after the other.. (Full backup,
differential backup and transactional backup..)
My question is..
After restoring the MASTER database, all the user databases information is
restored in the master database.
So.. Is it possible to restore the user database as the entries exist in
MASTER database? Is it possible to restore the user database just like any
other time that we restore the user database under different database name?
Since I cannot test the complete scenario I am looking for your opinion..
I am using SQL Server 2K.
Thank you all for your opinion.
Hanuman
Hi,
You can restore the user databases in any order. The order will not really
matter. You can also restore the user databases with new name this will add
new entries to sysdatabases, but the old entries in sysdatabases will remain
there. Only issue is incase if you have any logins defaulted to ur old
database
name needs to be changed using SP_defaultdb system stored procedure.
Thanks
Hari
SQL Server MVP
"Hanuman Mishra" <Mishra_Hanuman@.rediffmail.com> wrote in message
news:OpwFwX8ZFHA.4000@.TK2MSFTNGP10.phx.gbl...
>
> In the event of SQL Server recovery... I have listed the following steps
> (not detailed) as per reading SQL Server books online.
> Step1. Install the SQL Server and related Service Packs
> Step2. Restore the master database.
> Step3. Restore the msdb (to restore the DTS packages and job schedules.)
> Stpe4. Restore other system databases if it is required (optional).
> Step5. Restore the user databases one after the other.. (Full backup,
> differential backup and transactional backup..)
>
> My question is..
> After restoring the MASTER database, all the user databases information is
> restored in the master database.
> So.. Is it possible to restore the user database as the entries exist in
> MASTER database? Is it possible to restore the user database just like any
> other time that we restore the user database under different database
> name?
> Since I cannot test the complete scenario I am looking for your opinion..
>
> I am using SQL Server 2K.
> Thank you all for your opinion.
> Hanuman
>

Question related to recovery of SQL Server database..

In the event of SQL Server recovery... I have listed the following steps
(not detailed) as per reading SQL Server books online.
Step1. Install the SQL Server and related Service Packs
Step2. Restore the master database.
Step3. Restore the msdb (to restore the DTS packages and job schedules.)
Stpe4. Restore other system databases if it is required (optional).
Step5. Restore the user databases one after the other.. (Full backup,
differential backup and transactional backup..)
My question is..
After restoring the MASTER database, all the user databases information is
restored in the master database.
So.. Is it possible to restore the user database as the entries exist in
MASTER database? Is it possible to restore the user database just like any
other time that we restore the user database under different database name?
Since I cannot test the complete scenario I am looking for your opinion..
I am using SQL Server 2K.
Thank you all for your opinion.
HanumanHi,
You can restore the user databases in any order. The order will not really
matter. You can also restore the user databases with new name this will add
new entries to sysdatabases, but the old entries in sysdatabases will remain
there. Only issue is incase if you have any logins defaulted to ur old
database
name needs to be changed using SP_defaultdb system stored procedure.
Thanks
Hari
SQL Server MVP
"Hanuman Mishra" <Mishra_Hanuman@.rediffmail.com> wrote in message
news:OpwFwX8ZFHA.4000@.TK2MSFTNGP10.phx.gbl...
>
> In the event of SQL Server recovery... I have listed the following steps
> (not detailed) as per reading SQL Server books online.
> Step1. Install the SQL Server and related Service Packs
> Step2. Restore the master database.
> Step3. Restore the msdb (to restore the DTS packages and job schedules.)
> Stpe4. Restore other system databases if it is required (optional).
> Step5. Restore the user databases one after the other.. (Full backup,
> differential backup and transactional backup..)
>
> My question is..
> After restoring the MASTER database, all the user databases information is
> restored in the master database.
> So.. Is it possible to restore the user database as the entries exist in
> MASTER database? Is it possible to restore the user database just like any
> other time that we restore the user database under different database
> name?
> Since I cannot test the complete scenario I am looking for your opinion..
>
> I am using SQL Server 2K.
> Thank you all for your opinion.
> Hanuman
>

Question related to recovery of SQL Server database..

In the event of SQL Server recovery... I have listed the following steps
(not detailed) as per reading SQL Server books online.
Step1. Install the SQL Server and related Service Packs
Step2. Restore the master database.
Step3. Restore the msdb (to restore the DTS packages and job schedules.)
Stpe4. Restore other system databases if it is required (optional).
Step5. Restore the user databases one after the other.. (Full backup,
differential backup and transactional backup..)
My question is..
After restoring the MASTER database, all the user databases information is
restored in the master database.
So.. Is it possible to restore the user database as the entries exist in
MASTER database? Is it possible to restore the user database just like any
other time that we restore the user database under different database name?
Since I cannot test the complete scenario I am looking for your opinion..
I am using SQL Server 2K.
Thank you all for your opinion.
HanumanHi,
You can restore the user databases in any order. The order will not really
matter. You can also restore the user databases with new name this will add
new entries to sysdatabases, but the old entries in sysdatabases will remain
there. Only issue is incase if you have any logins defaulted to ur old
database
name needs to be changed using SP_defaultdb system stored procedure.
Thanks
Hari
SQL Server MVP
"Hanuman Mishra" <Mishra_Hanuman@.rediffmail.com> wrote in message
news:OpwFwX8ZFHA.4000@.TK2MSFTNGP10.phx.gbl...
>
> In the event of SQL Server recovery... I have listed the following steps
> (not detailed) as per reading SQL Server books online.
> Step1. Install the SQL Server and related Service Packs
> Step2. Restore the master database.
> Step3. Restore the msdb (to restore the DTS packages and job schedules.)
> Stpe4. Restore other system databases if it is required (optional).
> Step5. Restore the user databases one after the other.. (Full backup,
> differential backup and transactional backup..)
>
> My question is..
> After restoring the MASTER database, all the user databases information is
> restored in the master database.
> So.. Is it possible to restore the user database as the entries exist in
> MASTER database? Is it possible to restore the user database just like any
> other time that we restore the user database under different database
> name?
> Since I cannot test the complete scenario I am looking for your opinion..
>
> I am using SQL Server 2K.
> Thank you all for your opinion.
> Hanuman
>

Question regarding DataSet file (xsd) like the ones used on 3-teir design tutorial

Hi everyone,

I have a question. I am using a DataSet file as my data layer in my app. I'm trying to create a event TableAdaptor where one of the queries has two paramaters (@.start & @.end). Those two variables are used to search for items that have start dates that fall in between the two.

Every time I try to use this, the smart tab always brings up three paramaters (DataTable, start as date, end as date). How the hell does that DataTable get thrown in there. I executed the query in the builder section and it only asks for the two variables.

Any idea on this one?

Thanks!

A dataset is a collection of datatables|||

That part I knew, I'm just wondering why it's asking for it. I've created numerous tableAdapter and this is the first one that inserted a variable I don't need.

Here is the query I'm using inside the xsd, as you can see I only have two variables (@.start & @.end), so why does it generate a third variable of type DataTable?

========================================================================================

SELECT eventID,
eventTitle,
eventDescription,
eventStartTimeDate,
eventEndTimeDate,
eventCategoryID,
( SELECT eventCategoryName
FROM eventCategories
WHERE eventCategoryID = events.eventCategoryID
) AS eventCategoryName
FROM events
WHERE (eventStartTimeDate >= @.start AND eventStartTimeDate < @.end)
AND active = 1

|||

Hi,

Is the DataTable variable generated for the Fill method of DataTable? If yes, it is by design.

The Fill method needs to know the destination the select data flows to. In this case, you will need to supply an argument of DataTable type.

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!