How to create Backup of database for a fixed time?
-
Hi HOw to create Backup of database using query for a fixed time? I do not want to use Wizard. plz help as soon as possible. Thanks
-
Hi HOw to create Backup of database using query for a fixed time? I do not want to use Wizard. plz help as soon as possible. Thanks
This will create a backup:
BACKUP DATABASE pubs TO DISK = N'c:\temp\pubs.bak'but I have no idea if that's what you need, since I don't know what you mean by 'for a fixed time'. Could you explain? -
This will create a backup:
BACKUP DATABASE pubs TO DISK = N'c:\temp\pubs.bak'but I have no idea if that's what you need, since I don't know what you mean by 'for a fixed time'. Could you explain?Thnks for replay BACKUP DATABASE Parikrama TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\SQLSpyNetJob.bak' WITH NOINIT, NOSKIP, STATS = 10 can anyone tell wht is the meaning of STATS =10 in above query. And plz tell me i want query tht taking automatically bacup of database with in interval0f 10-10 minutes by job scheduler . Thanks
-
Thnks for replay BACKUP DATABASE Parikrama TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\SQLSpyNetJob.bak' WITH NOINIT, NOSKIP, STATS = 10 can anyone tell wht is the meaning of STATS =10 in above query. And plz tell me i want query tht taking automatically bacup of database with in interval0f 10-10 minutes by job scheduler . Thanks
Care Career wrote:
database
SQL Server Books On Line[^] are your friend. That means with statistics update based on a 10% sample of the data. Creating a backup every 10 minutes is only likely to work for a very small database, as backup can take more time than this. Creating a job to do this on a scheduled interval takes more than one query, and is best done using the database maintenance wizard. It is possible manually, but the procedure is more lengthy than can be described here. Use the reference I have provided, and look up SQL Server Agent tasks, or Database maintenance.
-
Care Career wrote:
database
SQL Server Books On Line[^] are your friend. That means with statistics update based on a 10% sample of the data. Creating a backup every 10 minutes is only likely to work for a very small database, as backup can take more time than this. Creating a job to do this on a scheduled interval takes more than one query, and is best done using the database maintenance wizard. It is possible manually, but the procedure is more lengthy than can be described here. Use the reference I have provided, and look up SQL Server Agent tasks, or Database maintenance.
thnx lot Can u tell how to start Sql server agent? 1069 logon faliure error is coming when i start sql server agent. Thnx
-
thnx lot Can u tell how to start Sql server agent? 1069 logon faliure error is coming when i start sql server agent. Thnx
Try to search for yourself before you ask - this is the first result Google gave me: http://www.mssqlcity.com/FAQ/Trouble/error_1069.htm[^]. What account does SQL Server Agent use on your machine?
-
Care Career wrote:
database
SQL Server Books On Line[^] are your friend. That means with statistics update based on a 10% sample of the data. Creating a backup every 10 minutes is only likely to work for a very small database, as backup can take more time than this. Creating a job to do this on a scheduled interval takes more than one query, and is best done using the database maintenance wizard. It is possible manually, but the procedure is more lengthy than can be described here. Use the reference I have provided, and look up SQL Server Agent tasks, or Database maintenance.
Rob Graham wrote:
That means with statistics update based on a 10% sample of the data.
Are you sure? This is what I found:
STATS [ = percentage ] Displays a message each time another percentage completes, and is used to gauge progress. If percentage is omitted, SQL Server displays a message after each 10 percent is completed. The STATS option reports the percentage complete as of the threshold for reporting the next interval. This is at approximately the specified percentage; for example, with STATS=10, if the amount completed is 40 percent, the option might display 43 percent. For large backup sets, this is not a problem, because the percentage complete moves very slowly between completed I/O calls.