dxb
05-30-2005, 04:45 AM
Im super newbie to sql and our website is creating a big problem that has to do with our database. anyway this is the respose from our host on what we have to do with it.
You can create a SQL Query that will clear your SQL Transaction Logs:
BACKUP LOG Your_Database_Name_Goes_Here WITH TRUNCATE_ONLY DBCC CHECKDB(Your_Database_Name_Goes_Here)
DBCC CHECKCATALOG(Your_Database_Name_Goes_Here)
BACKUP DATABASE Your_Database_Name_Goes_Here TO DISK = 'H:\Backup\Clients\Your_Database_Name_Goes_Here\Yo ur_Database_Name_Goes_
Here_Full_Backup' WITH INIT
NOTE: Make sure that you change each instance of Your_Database_Name_Goes_Here to your actual Database name.
The first line of the query will back-up the log and truncate it.
The following 3 lines will check and back-up your database.
pls help me cause i know nothing about this.
You can create a SQL Query that will clear your SQL Transaction Logs:
BACKUP LOG Your_Database_Name_Goes_Here WITH TRUNCATE_ONLY DBCC CHECKDB(Your_Database_Name_Goes_Here)
DBCC CHECKCATALOG(Your_Database_Name_Goes_Here)
BACKUP DATABASE Your_Database_Name_Goes_Here TO DISK = 'H:\Backup\Clients\Your_Database_Name_Goes_Here\Yo ur_Database_Name_Goes_
Here_Full_Backup' WITH INIT
NOTE: Make sure that you change each instance of Your_Database_Name_Goes_Here to your actual Database name.
The first line of the query will back-up the log and truncate it.
The following 3 lines will check and back-up your database.
pls help me cause i know nothing about this.