sql record counts: directory

Showing posts with label directory. Show all posts

Tuesday, March 27, 2012

difference between Owned schemas and Roles members

Hi,
I want to create a login (for account ASPNET from the Active Directory) in
sql server express 2005 for a specific database.
When addidng a new user to a specific database, i see:
Owned schemas, where i take db_datareader and db_datawriter
Roles memmbers: also db_datareader and db_datawriter
What's the difference between both and are they both required fpr account
ASPNET?
Tbanks
BartThis is answered
"Bart" <b@.sdq.dc> schreef in bericht
news:%23buSVSjbHHA.1400@.TK2MSFTNGP06.phx.gbl...
> Hi,
> I want to create a login (for account ASPNET from the Active Directory) in
> sql server express 2005 for a specific database.
> When addidng a new user to a specific database, i see:
> Owned schemas, where i take db_datareader and db_datawriter
> Roles memmbers: also db_datareader and db_datawriter
> What's the difference between both and are they both required fpr account
> ASPNET?
> Tbanks
> Bart
>

Friday, March 9, 2012

Diagram bug in 2005 Developer edition

I have a few databases which were created using sql server 2000 developer
edition. I copied them to the directory where the sql server 2005 databases
are located. I used "Attach" by right clicking on databases and attached the
databases. When I went to view the diagrams, I got a message that database
diagram support can not be installed because the database does not have a
valid user. Strange I thought since I'm using a laptop and everything else
was installed under the same Windows XP login. So I changed the owner to 'sa
'
and I got the same error message. I fixed the problem by changing the
compatability from 8.0 to 9.0. I did not change the owner on the other
databases that I attached. I got a message for sql server to install object
support, I had it install it and then I could view the diagrams just fine.I don't know if it's considered a bug but it is documented
in the read me file - ReadMeSQL2005.htm which should be off
the root of your installation media. I believe the next
update to BOL will have this documented as well. In the read
me file, check section 4.8.1 titled
Considerations for Installing Database Diagram Support
-Sue
On Thu, 13 Apr 2006 10:22:01 -0700, Doctor Who
<DoctorWho@.discussions.microsoft.com> wrote:

>I have a few databases which were created using sql server 2000 developer
>edition. I copied them to the directory where the sql server 2005 databases
>are located. I used "Attach" by right clicking on databases and attached th
e
>databases. When I went to view the diagrams, I got a message that database
>diagram support can not be installed because the database does not have a
>valid user. Strange I thought since I'm using a laptop and everything else
>was installed under the same Windows XP login. So I changed the owner to 's
a'
>and I got the same error message. I fixed the problem by changing the
>compatability from 8.0 to 9.0. I did not change the owner on the other
>databases that I attached. I got a message for sql server to install object
>support, I had it install it and then I could view the diagrams just fine.

Diagram bug in 2005 Developer edition

I have a few databases which were created using sql server 2000 developer
edition. I copied them to the directory where the sql server 2005 databases
are located. I used "Attach" by right clicking on databases and attached the
databases. When I went to view the diagrams, I got a message that database
diagram support can not be installed because the database does not have a
valid user. Strange I thought since I'm using a laptop and everything else
was installed under the same windows xp login. So I changed the owner to 'sa'
and I got the same error message. I fixed the problem by changing the
compatability from 8.0 to 9.0. I did not change the owner on the other
databases that I attached. I got a message for sql server to install object
support, I had it install it and then I could view the diagrams just fine.I don't know if it's considered a bug but it is documented
in the read me file - ReadMeSQL2005.htm which should be off
the root of your installation media. I believe the next
update to BOL will have this documented as well. In the read
me file, check section 4.8.1 titled
Considerations for Installing Database Diagram Support
-Sue
On Thu, 13 Apr 2006 10:22:01 -0700, Doctor Who
<DoctorWho@.discussions.microsoft.com> wrote:
>I have a few databases which were created using sql server 2000 developer
>edition. I copied them to the directory where the sql server 2005 databases
>are located. I used "Attach" by right clicking on databases and attached the
>databases. When I went to view the diagrams, I got a message that database
>diagram support can not be installed because the database does not have a
>valid user. Strange I thought since I'm using a laptop and everything else
>was installed under the same windows xp login. So I changed the owner to 'sa'
>and I got the same error message. I fixed the problem by changing the
>compatability from 8.0 to 9.0. I did not change the owner on the other
>databases that I attached. I got a message for sql server to install object
>support, I had it install it and then I could view the diagrams just fine.

DHCP Service fails to start after installing SQL Server 2005 April CTP

I have a Windows 2003 Server SP1, Active Directory, Application Server and RIS installed on my computer. After installing SQL Server 2005 April CTP my DHCP Service fails to start. In the Event Viewer I see the following Events.

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Information
Event Source: Application Popup
Description: Application popup: Service Control Manager: At least one service or driver failed during system startup. Use Event Viewer to examine the event log for details.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to restore the database. The following error occurred: An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.

Event Type: Error
Event Source: DhcpServer
Description: The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I also have this same problem after installing the june sql server 2005 ctp. Tried restore of dhcp database. Tried to create empty database. Uninstalled service and app. Uninstalled the dhcp server and sql server 2005 and then reinstalled dhcp server and still the same problem.

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1014
===========
The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.
===========

Error 1018
===========
The DHCP service failed to restore the database. The following error occurred:
An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

|||Oh, great. I'm having this issue too. It must be. I installed the SQL Server CTP a few weeks ago, didn't like it very much and uninstalled. Now I'm trying to install DHCP Server and I can't. I get the same error messages in the EventLog which you describe.

Hasn't this been solved yet?

Sad |||I think someone from Microsoft should address this issue.

Thanks,|||Anybody ever get a resolution to this, I've seen it mentioned in all sorts of forums, one of which indicated there was a registry fix posted on the MSDN site but I can't find a fix anywhere. Microsoft whats the deal? How do we fix these problems?|||Hi Mark,

Thanks for weighing in. I found this thread from a Google search and it was way down on the list in this forum. But I can't see that anyone has ever fixed this! As soon as I posted my own problem, the topic popped up to the top of the list. That's the nice thing about this forum. So everyone who is having this problem needs to report in. This will keep this at the top of the list and hopefully get Microsoft's attention. They really need to fix this.

Workaround tip: This may be a *duh* or this may not be obvious to you; I didn't realize this solution at first. If you're connected to the Internet via a Router/Switch, it is possible that the router device can provide DHCP services for you. My LinkSys CableModem router provides DHCP, so I'm OK personally, but Microsoft really should fix this.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

(As a side note, why on Earth is DHCP Server using a Jet database? For goodness sakes, it's 2005!)|||http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=6c2ce44d-72d2-416d-afee-c51c9298c746
This issue is because setup creates wrong default registry value under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\VssAccessControl. To fix DHCP service just delete VssAccessControl registry key.
|||It worked! Thanks a lot.
Mike
|||

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

|||Experiencing the exact same problem. There is no "VssAccessControl" registery key. DHCP is starting but each moring it shuts down.|||Worked for me.. thanks|||I am still having this issue as well. I am getting event ids 1010, 1016, and 1014. I don't have SQL installed on this computer at all. Please help.|||I am getting this same issue, but about the same time I started receiving errors from Executive Software Diskeeper Enterprise edition, telling me that I could no longer defrag my root drive, as I had Volume shadow copy enabled. This software had always worked fine before on this system and the only changed I can tie this too are the critical updates released last week.
|||

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

Hasn't this been solved yet?

Sad |||I think someone from Microsoft should address this issue.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

Hasn't this been solved yet?

Sad |||I think someone from Microsoft should address this issue.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

Hasn't this been solved yet?

Sad |||I think someone from Microsoft should address this issue.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

Hasn't this been solved yet?

Sad |||I think someone from Microsoft should address this issue.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

Hasn't this been solved yet?

Sad |||I think someone from Microsoft should address this issue.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

Hasn't this been solved yet?

Sad |||I think someone from Microsoft should address this issue.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

Hasn't this been solved yet?

Sad |||I think someone from Microsoft should address this issue.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

Hasn't this been solved yet?

Sad |||I think someone from Microsoft should address this issue.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

Tuesday, February 14, 2012

Determining restore sequence

Hi,
I have a lot of files in a directory. Each one have exactly one SQL Backup
Set. There are full, differential and transaction-log backup files...
How can I know what files (diffs and tlogs) should be restored (and in what
order) considering a individual full backup file (to get a the most recent
state)?
I am trying to use DatabaseBackupLSN and LastLSN. And I am having special
problems with the transaction-log backups (where to restore or not after a
specific differential).
Can anyone help me?
Thanks,
Rafael PivatoThe easiest way is to go by the time/date stamp in the
file name, which you should be using. Or by the file
dates.
Now, you need a full, and then after that, you can do the
differential after the full, and the transaction logs
after that. Or the full and all the tran logs after that.
You should keep a document somewhere that details these
things.
>--Original Message--
>Hi,
>
>I have a lot of files in a directory. Each one have
exactly one SQL Backup
>Set. There are full, differential and transaction-log
backup files...
>
>How can I know what files (diffs and tlogs) should be
restored (and in what
>order) considering a individual full backup file (to get
a the most recent
>state)?
>
>I am trying to use DatabaseBackupLSN and LastLSN. And I
am having special
>problems with the transaction-log backups (where to
restore or not after a
>specific differential).
>
>
>Can anyone help me?
>Thanks,
>Rafael Pivato
>
>
>.
>|||Hi,
Allways try to create transaction log backup file names
with the combination of TX_date_time.bak.
Thanks
Hari
"Allan Hirt" <allanh@.nospamavanade.com> wrote in message
news:02f201c3cc0e$650a5410$a101280a@.phx.gbl...
> The easiest way is to go by the time/date stamp in the
> file name, which you should be using. Or by the file
> dates.
> Now, you need a full, and then after that, you can do the
> differential after the full, and the transaction logs
> after that. Or the full and all the tran logs after that.
> You should keep a document somewhere that details these
> things.
> >--Original Message--
> >Hi,
> >
> >
> >
> >I have a lot of files in a directory. Each one have
> exactly one SQL Backup
> >Set. There are full, differential and transaction-log
> backup files...
> >
> >
> >
> >How can I know what files (diffs and tlogs) should be
> restored (and in what
> >order) considering a individual full backup file (to get
> a the most recent
> >state)?
> >
> >
> >
> >I am trying to use DatabaseBackupLSN and LastLSN. And I
> am having special
> >problems with the transaction-log backups (where to
> restore or not after a
> >specific differential).
> >
> >
> >
> >
> >
> >Can anyone help me?
> >
> >Thanks,
> >
> >Rafael Pivato
> >
> >
> >
> >
> >.
> >|||Read the file names into a temp table, ordered by its last modify date/time.
Loop through the temp table to examine each file with 'RESTORE HEADERONLY.'
This will tell you, among other things, the backup type of the backup file
or whether it is even a backup file. Keep only the latest full database
backup file, toss away any differential backup files older than the lastest
full database backup, and toss away any tran log backup files older than the
latest differential backup or the latest full database backup if there is no
differential backup.
Construct the RESTORE script in the following order:
1. Construct the database RESTORE statement by running RESTORE FILELISTONLY.
2. Construct the differential RESTORE statement by running RESTORE
FILELISTONLY on the differential backup file.
3. Construct the log RESTORE statements by running RESTORE FILELISTONLY on
each of the log backup files in the chronological order.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Rafael Pivato" <for@.get.it> wrote in message
news:%23Sm0yx%23yDHA.2116@.TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I have a lot of files in a directory. Each one have exactly one SQL Backup
> Set. There are full, differential and transaction-log backup files...
>
> How can I know what files (diffs and tlogs) should be restored (and in
what
> order) considering a individual full backup file (to get a the most recent
> state)?
>
> I am trying to use DatabaseBackupLSN and LastLSN. And I am having special
> problems with the transaction-log backups (where to restore or not after a
> specific differential).
>
>
> Can anyone help me?
> Thanks,
> Rafael Pivato
>
>

Tuesday, March 27, 2012

difference between Owned schemas and Roles members

Friday, March 9, 2012

Diagram bug in 2005 Developer edition

Diagram bug in 2005 Developer edition

DHCP Service fails to start after installing SQL Server 2005 April CTP

DHCP Service fails to start after installing SQL Server 2005 April CTP

DHCP Service fails to start after installing SQL Server 2005 April CTP

DHCP Service fails to start after installing SQL Server 2005 April CTP

DHCP Service fails to start after installing SQL Server 2005 April CTP

DHCP Service fails to start after installing SQL Server 2005 April CTP

DHCP Service fails to start after installing SQL Server 2005 April CTP

DHCP Service fails to start after installing SQL Server 2005 April CTP

DHCP Service fails to start after installing SQL Server 2005 April CTP

Tuesday, February 14, 2012

Determining restore sequence

sql record counts

Blog Archive

About Me