Sims.net Server2008 64Bit

[Steve_T]

Shrink the log is a good place to start and tidy up the database, if you have been using it along time think how much dead wood you have.

[steve]

We do a nightly backup that shrinks the ldf - its the mdf that's grown.

SIMS is used here very intensively - all lesson registers, assessment, profiles, personnel, you name it we use it, and use it a lot.

[Jobos]

Shrink the log is a good place to start and tidy up the database, if you have been using it along time think how much dead wood you have.

How do you shrink the log?

[steve]

From Supportnet:

1) Create a new user in SIMS .net, making them a member of the System Manager group and also a trusted SIMS .net user

2) Create a batch file containing the following

DBATTACH /SERVER="server\sims" /DATABASE="SIMS" /BACKUP /AUTO /TRUSTED

if ERRORLEVEL 1 GOTO :ERROR
GOTO :END
:ERROR
ECHO NOT WORKING
:END

3) Create a scheduled task to run the batch file the with the users credentials as in 1)

The task will then run whether the user is logged in or not


A Scheduled Task is set up via:-
Start | Control Panel | Scheduled Tasks | Add Schedule Tasks
Follow the on screen instructions and browse to the batch file that will run the backup

[Steve_T]

As Steve said above or user SQL Management Studio it wont bite. A huge amount problems can be resolved with a few clicks using Management studio. See attachment.

[Oops_my_bad]

From Supportnet:

1) Create a new user in SIMS .net, making them a member of the System Manager group and also a trusted SIMS .net user

2) Create a batch file containing the following

DBATTACH /SERVER="server\sims" /DATABASE="SIMS" /BACKUP /AUTO /TRUSTED

if ERRORLEVEL 1 GOTO :ERROR
GOTO :END
:ERROR
ECHO NOT WORKING
:END

3) Create a scheduled task to run the batch file the with the users credentials as in 1)

The task will then run whether the user is logged in or not


A Scheduled Task is set up via:-
Start | Control Panel | Scheduled Tasks | Add Schedule Tasks
Follow the on screen instructions and browse to the batch file that will run the backup

Is there anyway to get dbattach to automatically detach the database so you can backup the actual .mdf and .ldf? I can think of a few situations where the .bak scripts would be pretty useless in the event of a restore...

[matt40k]

Is there anyway to get dbattach to automatically detach the database so you can backup the actual .mdf and .ldf? I can think of a few situations where the .bak scripts would be pretty useless in the event of a restore...

Just top the SQL service (net stop mssql$sims2005) copy the .mdf/.ldf then start MSSQL (net start mssql$sims2005)

Yet to hear of a case where the .bak can't be used to be honest.

FYI: if you do copy the .mdf etc, take a copy of master.

Whilst on the subject, if you use FMS, it MUST BE BACKED UP AT THE SAME TIME AND BOTH RESTORED FROM THE SAME TIME.

caps off

[Steve_T]

MUST BE BACKED UP AT THE SAME TIME AND BOTH RESTORED FROM THE SAME TIME.

Make sure you do take note of the above or you will encounter problems regarding Unsynchronised databases.