Hi Guys,
I've a problem regarding transaction log, i have a databasse
which is to be accessed very rairaly inspite of that after few days it shows
warning as:
APPROACHING RESOURCE LIMIT
MSSQL Quota DB: ABCD_database has used 66 MB out of 80 MB limit
while i don't have control on my DB some other company takes
care of my DB operation like truncating transaction log etc. when i talked
with them they said that transaction log auto truncates several time in a day.
i don't know where the problem exists,
please help me
They should define "auto truncate". Auto shrink is different from backing
up the log or having the recovery model set to simple.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Manish Sukhija" <ManishSukhija@.discussions.microsoft.com> wrote in message
news:BCCE0C43-64CC-4FF2-92A9-188B3346C6D4@.microsoft.com...
Hi Guys,
I've a problem regarding transaction log, i have a databasse
which is to be accessed very rairaly inspite of that after few days it shows
warning as:
APPROACHING RESOURCE LIMIT
MSSQL Quota DB: ABCD_database has used 66 MB out of 80 MB limit
while i don't have control on my DB some other company takes
care of my DB operation like truncating transaction log etc. when i talked
with them they said that transaction log auto truncates several time in a
day.
i don't know where the problem exists,
please help me
|||What database options are turned on? How much data is actually in the
database?
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Manish Sukhija" <ManishSukhija@.discussions.microsoft.com> wrote in message
news:BCCE0C43-64CC-4FF2-92A9-188B3346C6D4@.microsoft.com...
> Hi Guys,
> I've a problem regarding transaction log, i have a databasse
> which is to be accessed very rairaly inspite of that after few days it
> shows
> warning as:
> APPROACHING RESOURCE LIMIT
> MSSQL Quota DB: ABCD_database has used 66 MB out of 80 MB limit
> while i don't have control on my DB some other company
> takes
> care of my DB operation like truncating transaction log etc. when i talked
> with them they said that transaction log auto truncates several time in a
> day.
> i don't know where the problem exists,
> please help me
>
sql
Showing posts with label transaction. Show all posts
Showing posts with label transaction. Show all posts
Tuesday, March 27, 2012
Friday, February 24, 2012
File locations
Is it possible to reassign the data and transaction log file locations after
creating a DB? If so how? Thanks to everyone for being there to help. SQL
server 2000
Simplest way would be to detach the database, move it to a new location an
then attach it again (not recommended for a production database).
Cristian Lefter, SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000
|||Cristian's advice is sound but you may find these helpful:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000
|||Hi,
1. Use the procedure SP_DETACH_DB <dbname> to detach the database
2. Create a new folder in new drive and copy the MDF and LDF to new folder
3. Use sp_attach_db
'dbname','driveletter\folder\dXbname.mdf','drivele tter\folderX\dbname.ldf'
FYI, This approach need some down time.
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000
creating a DB? If so how? Thanks to everyone for being there to help. SQL
server 2000
Simplest way would be to detach the database, move it to a new location an
then attach it again (not recommended for a production database).
Cristian Lefter, SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000
|||Cristian's advice is sound but you may find these helpful:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000
|||Hi,
1. Use the procedure SP_DETACH_DB <dbname> to detach the database
2. Create a new folder in new drive and copy the MDF and LDF to new folder
3. Use sp_attach_db
'dbname','driveletter\folder\dXbname.mdf','drivele tter\folderX\dbname.ldf'
FYI, This approach need some down time.
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000
File locations
Is it possible to reassign the data and transaction log file locations after
creating a DB? If so how? Thanks to everyone for being there to help. SQL
server 2000Simplest way would be to detach the database, move it to a new location an
then attach it again (not recommended for a production database).
Cristian Lefter, SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000|||Cristian's advice is sound but you may find these helpful:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000|||Hi,
1. Use the procedure SP_DETACH_DB <dbname> to detach the database
2. Create a new folder in new drive and copy the MDF and LDF to new folder
3. Use sp_attach_db
'dbname','driveletter\folder\d_bname.mdf','driveletter\folder_\dbname.ldf'
FYI, This approach need some down time.
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000
creating a DB? If so how? Thanks to everyone for being there to help. SQL
server 2000Simplest way would be to detach the database, move it to a new location an
then attach it again (not recommended for a production database).
Cristian Lefter, SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000|||Cristian's advice is sound but you may find these helpful:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000|||Hi,
1. Use the procedure SP_DETACH_DB <dbname> to detach the database
2. Create a new folder in new drive and copy the MDF and LDF to new folder
3. Use sp_attach_db
'dbname','driveletter\folder\d_bname.mdf','driveletter\folder_\dbname.ldf'
FYI, This approach need some down time.
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000
File locations
Is it possible to reassign the data and transaction log file locations after
creating a DB? If so how? Thanks to everyone for being there to help. SQL
server 2000Simplest way would be to detach the database, move it to a new location an
then attach it again (not recommended for a production database).
Cristian Lefter, SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000|||Cristian's advice is sound but you may find these helpful:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000|||Hi,
1. Use the procedure SP_DETACH_DB <dbname> to detach the database
2. Create a new folder in new drive and copy the MDF and LDF to new folder
3. Use sp_attach_db
'dbname','driveletter\folder\dbname.mdf','driveletter\folder\dbname.ldf'
FYI, This approach need some down time.
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000
creating a DB? If so how? Thanks to everyone for being there to help. SQL
server 2000Simplest way would be to detach the database, move it to a new location an
then attach it again (not recommended for a production database).
Cristian Lefter, SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000|||Cristian's advice is sound but you may find these helpful:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000|||Hi,
1. Use the procedure SP_DETACH_DB <dbname> to detach the database
2. Create a new folder in new drive and copy the MDF and LDF to new folder
3. Use sp_attach_db
'dbname','driveletter\folder\dbname.mdf','driveletter\folder\dbname.ldf'
FYI, This approach need some down time.
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000
Subscribe to:
Posts (Atom)