Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Taking database offline each night for a backup
Message
From
21/03/2006 13:11:57
 
 
To
21/03/2006 10:55:36
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01105541
Message ID:
01106303
Views:
32
Hi,

I think we're slipping cogs on this one. Anyway, we're agreed that SQLServer can make a coherent backup of an active database without third party additions, right?

Best,
Viv


>I think that is what I have been talking about. You have to tell MSSql how and when to backup. The only other backup, per say, that I know of is the transaction log. I have not worked with SQL 2005 so it may have more. I do most of my work with Sybase ASA database and it works a little different.
>
>>>>Of course, the best way is to purchase good backup software that can backup a running database.
>>>>
>>>>This is where I came into this thread. Doesn't SQLServer do this anyway?
>>>
>>>I am not sure what you mean?
>>
>>Doesn't SQLServers' built-in option backup an active database?
>>Regards,
>>Viv
Previous
Reply
Map
View

Click here to load this message in the networking platform